1 Reply Latest reply: Jul 24, 2018 8:44 AM by Simran Tuli RSS

    Qlik Sense,Bar Char Drilldown to a table

    Xu Zhao

      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 ?

        • Re: Qlik Sense,Bar Char Drilldown to a table
          Simran Tuli

          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