Qlik Sense,Bar Char Drilldown to a table

[Anonymous]

Hi

I have a special requirement,

I have a Bar Chart, if I click the Bar Chart, then the Bar Chart disappeared  and show me a table.

any extension can do that ?

[simran04]

Hi Xu,

Drilling down from a bar chart to a straight table is not possible in QlikView/ Qlik Sense without using Extensions. Not sure whether it can be done using extensions also.

As a workaround, what you can do is you can make use of the "Calculation Condition" present under "Add Ons" tab.

I have made a bar chart and a straight table. Now, in the calculation condition of the bar chart and the table, I will write the following statements respectively.

Bar Chart: Calculation Condition: GetSelectedCount(Company)=0 [The bar chart will not disappear until a Company is selected].

Straight Table: Calculation Condition: GetSelectedCount(Company)<>0 [The straight table will not appear until a Company is selected]

As soon as a Company is selected from the bar chart, the bar chart will disappear and the straight table will appear.