Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
xz103389
Contributor
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
Contributor II
Contributor II

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