# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

## How to use a Sum If in Qlik Sense

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

7 Replies
Honored Contributor II

## Re: How to use a Sum If in Qlik Sense

try replacing ABOVE with BEFORE

Not applicable

## Re: How to use a Sum If in Qlik Sense

Thank you but it is still not working.

Honored Contributor II

## Re: How to use a Sum If in Qlik Sense

could you post a sample qvf ?

Not applicable

## Re: How to use a Sum If in Qlik Sense

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

MVP

## Re: How to use a Sum If in Qlik Sense

Which direction are you accumulating? vertically or horizontally?

Not applicable

## Re: How to use a Sum If in Qlik Sense

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

Valued Contributor

## Re: How to use a Sum If in Qlik Sense

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