7 Replies Latest reply: Aug 21, 2017 10:55 AM by bruno bertels RSS

    How to use a Sum If in Qlik Sense

    arturo salcido

      I use this formula in excel so i can calculate the cumulative frequency (like a Pareto), i need that numbers with a value less than 60% in red, between 60% and 90% yellow and more than 90% in green.

       

      =SUMIF($B$2:$F$6,">="&B2)/SUM($B$2:$F$6)

       

      Capture.PNG

       

      PD

      =if(sum(Total)=0,white(),

      colormix1(sum(Total)/$(=max(aggr(sum(Total),LOSS))),Green(),red())) is not useful because it doesnt go through yellow and it's not so exactly.

       

      And neither this formula works

       

      =if(sum(Total)=0,white(),

      if(rangesum(above(sum(Total),0,rowno()))/sum(TOTAL Total)<0.6,red(),

      if(rangesum(above(sum(Total),0,rowno()))/sum(TOTAL Total)>0.9,Yellow(),

      green())))

       

      2Capture.PNG