Forum Discussion

Applicable88's avatar
Applicable88
Icon for Impactful Individual rankImpactful Individual
5 years ago

Dynamic Switching Tables and Barchart

Hello,

I'm a former Qlik-User. In Qlik we had the following possiblities:

For example my data tracks all orders. There are subsets of deliverd and to be delivered orders.

Now instead of two tables I just want one dynamic table and also a bar chart that I can switch between these two modes. 

In Qlik I setup a variable that can be in two states, 1 or 0. I can link that variable in my visualisation to a dynamic button to switch between one and zero. Then I link the variable also to the table, for example a condition when the button is on 0 it shows delivered orders or the counts of all orders delivered, and when set on 1 count all orders not that are not delivered yet, where I need to plan manpower for. 

 

But that functionality doesn't stop here: according to 1 or 0 also the title of the table can change. Name of the table when button is on 0 is "Delivered Orders" when on 1 "Orders to be planned" and also one column in the dynamic table or bar chart changes from "delivered date" to "planned delivery date" or vice versa. 

Big advantage: saving space and compact visualisation, very intuitive, user don't have to scroll so much hence saving space, you only see what you need to see because with one click in that mode (delivered or to be planned) you filter everything out and don't need fuzzy slicer or so.....

 

Sorry for the long text, I hope someone understands the issue here. 

Best.

 

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • Applicable88's avatar
    Applicable88
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    Hi  amitchandak,

    thanks for quick reply.

    I understand the concept of bookmarsk. Which is only "saving" the filters that you chosed for quick and handy use. 

    My "interactive tables and bar chart" goes further I think, since it needs the dimension to change as well.  Imagine you have a button, one is called "show delivered orders" and the other is "show me orders to be plan". Now I have a bar-chart. When the first button is engaged it shows me the count of all delivered orders according to the time it was really dispatched (ActualdispatchedDate):

    ordernumberstatusPlannedDateActualdispatchdate
    234234DLVR01.01.202101.01.2021
    342342PLAN15.03.2021 
    444444DLVR04.02.202105.02.2021
    334322PLAN05.04.2021 
    334322PLAN06.04.2021 

    As you can see all orders not yet delivered and needs to be planned have no value in Actualdispatchdate, since they are still in warehouse.

    Now if I engage the second button the bar chart shows me the count of all ordernumbers which needs to be planned BUT  according to the "PlannedDate" column of course, since it has not been dispatched yet, and no dispatcheddate value is existing yet.

    So this is what I call a interactive Barchart. And I also want the same for a table:

    When "delivered" is engaged show me table with "actualdispatchedDate" and when "planned" button is engaged show me table with "plannedDate" column. All in the same interactive table and bar chart. And according to the name of the table or chart also the names should change accordingly. 

     

    I'm concerned PowerBi doesn't has this ability.