How to use a Sum If in Qlik Sense

[#1]

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)

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

[agigliotti]

try replacing ABOVE with BEFORE

[#3]

Thank you but it is still not working.

[agigliotti]

could you post a sample qvf ?

[#5]

Yes, hope you can help me. And again really thank you very much.

[sunny_talwar]

Which direction are you accumulating? vertically or horizontally?

[#7]

I would like to compare the value against the total (as it could be seen in the excel); but i don't have really very clear how does the  RangeSum formula's work, what i need it's closer to the Colormix formula

[brunobertels]

Hi

Not sure it will helpfull but try this

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

ColorMix1( hrank( total column(1))/  noofrows(TOTAL), lightred(), LightGreen()))

regards

Bruno