topic Re: rank and aggr function in QlikView

rank and aggr function

Mon, 29 Jun 2015 12:18:03 GMT

Hello,

I am working on a aggregation ranking function and i have actual one problem.

i want to calculate my aggregation/ranking only for the [Masch.-Nr.]='01-11' but i tried several set analysis filters but its still not working.

my aggr. looks like

=concat(if(Aggr(rank(min(Aggr(sum(Ist_P)*-1,Woche,[Masch.-Nr.], Jahr))),Woche)<=3, Woche & ' / ' & Ist_P & chr(10)))

and the text box shows

but should show

17 / 1,5

27 / 1,6

26 / 1,7

I tried to set

{<[Masch.-Nr.]={'01-11}>} but not the right result.

Re: rank and aggr function

sunny_talwar — Mon, 29 Jun 2015 12:31:18 GMT

I am not sure how you are getting your expected output? There is not combination for 17 / 1,5, 27 / 1,6 and 26 / 1,7 for your current selection. Are we doing this for your current selection or on unselected data?

Best,

Sunny

Re: rank and aggr function

Wed, 01 Jul 2015 05:59:48 GMT

Hello Sunny,

Maybe this was not clear for the forum, but the combination was only an example, based on the actual data in the qvw it should be 17 / 1,9, 27 / 2,0, 26 / 2,1

Armin