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.








      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(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(),