Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

xz103389
New Contributor

Qlik Sense,Bar Char Drilldown to a table

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 ?

1 Reply
simran04
New Contributor II

Re: Qlik Sense,Bar Char Drilldown to a table

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.

Capture.PNG

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.

Capture1.PNG

Community Browser