topic Problem Rank expression in QlikView

Problem Rank expression

Anonymous — Fri, 25 Mar 2016 10:34:29 GMT

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

sunny_talwar — Fri, 25 Mar 2016 11:58:11 GMT

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

Gysbert_Wassenaar — Fri, 25 Mar 2016 12:03:42 GMT

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

swuehl — Fri, 25 Mar 2016 12:27:11 GMT

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)