7 Replies Latest reply: Jul 17, 2017 11:20 AM by Sunny Talwar RSS

    Qlik Sense Dimension Grouping

    Ozgur Cirak

      Hello,

       

      I have a table with objectives and key results attached to related objectives.

       

      ObjectiveKey ResultsPercentage
      Achieve 1M $ in EMEA salesMarketing50%
      Achieve 1M $ in EMEA sales
      PR25%
      Achieve 1M $ in EMEA sales
      Demo and Tests40%
      Achieve 1M $ in EMEA sales
      New Opportunities30%

       

      Im formatting a pivot table and with avg(percentage) calculation, i can find average percentage of an objective, in this case for Achieve 1M$ in EMEA sales is 36,25

       

      I need to count objectives with a %100 percentage as a KPI Item but i couldnt figure.

       

      So i decided to create a calculated dimension. I called it 'Status' and as a formula i wrote : if(avg([percentage]='1','Done','In Progress') But it didnt work.

       

      What can cause that?

       

      Best regards