Solved: Re: Problem Rank expression - Qlik Community

Anonymous · ‎2016-03-25

Hi, I have a problem when using this expression for the column Test3 IF (Rank (Total -SUM (tax))<=23, (tax), 0) with this data source.

The expression does not execute the total when I delete the dimension Code.

Exist one solution using the functiion aggr to get the following result?

Thank you

Gysbert_Wassenaar · ‎2016-03-25

Perhaps: sum(aggr(IF (Rank (Total -SUM (tax))<=23, (tax), 0),Dim1,Dim2,[Dim Code]))

talk is cheap, supply exceeds demand

sunny_talwar · ‎2016-03-25

What is the exact expression you are using? Do you have a sample you can share?

Gysbert_Wassenaar · ‎2016-03-25

Perhaps: sum(aggr(IF (Rank (Total -SUM (tax))<=23, (tax), 0),Dim1,Dim2,[Dim Code]))

talk is cheap, supply exceeds demand

swuehl · ‎2016-03-25

Or maybe (assuming a single Dim1 and Dim2 combination possible (which probably is not like in your real setting)):

Sum({<[Dim Code] = {"=Rank(Sum(tax))<=23"}>} tax)