topic Rank Function in QlikView

Rank Function

suvechha_b — Wed, 23 Oct 2013 14:08:08 GMT

please suggest how to use rank function in my variable :

vError:

sum(aggr(fabs(sum([Absolute Error])),[Product Code],[Fiscal Month],[Fiscal Year],Measure,[Division Product Manager Code]))

Re: Rank Function

Wed, 23 Oct 2013 14:18:34 GMT

Can you please explain the problem? I mean what exactly do you want to rank? Do you want to rank the sum of Absolute Numbers aggregated by multiple dimensions (mentioned in the code above)?

Re: Rank Function

suvechha_b — Wed, 23 Oct 2013 14:25:10 GMT

As I described above, I have an variable name vError which I am using in my expression but its not working according to the slider which I used.

For that I need to use the Rank function to work my slider.

the [Absolute Error] is not calculating according to the selection of slider.

Re: Rank Function

Wed, 23 Oct 2013 16:45:59 GMT

Can you please share a sample application? It will be easier that way.

Re: Re: Rank Function

suvechha_b — Wed, 23 Oct 2013 18:57:54 GMT

As I described above, I have an variable name vError which I am using in my expression but its not working according to the slider which I used.

For that I need to use the Rank function to work my slider.

the [Absolute Error] is not calculating according to the selection of slider.