1 Reply Latest reply: Mar 14, 2016 4:03 PM by Stefan Wühl RSS

    100 % stacked bar chart in qliksense with set analysis condition

    Brijesh Maurya

      Hi All ,

       

      I Have a Two Dimension

       

      Date  and TAB

       

      and Expression :

      Count(distinct{<Category= {'home'},Action={'scrol'}>} ID)

      /

      Count(distinct total <Date> {< Category= {'page'},Action={'open'},

      Url={'estate_*','buy'}>} ID)

       

       

      But i am not getting an 100% Bar chart .. Kinldy Help me for the same

        • Re: 100 % stacked bar chart in qliksense with set analysis condition
          Stefan Wühl

          Your set analysis filter for the numerator is different from the denominator.

           

          This might explain that the TOTAL<Date> Count does not match the sum of the single numerators.

           

          Also, using DISTINCT qualifier might lead to the sum of single numerators be higher than the denominator, if the TAB dimension values share IDs.

           

          In short, it's hard to tell what is going on or to give any advice without knowing your data model and data.