Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

rank and aggr function

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

29-06-_2015_14-11-13.jpg

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.

2 Replies
sunny_talwar

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?


Capture.PNG

Best,

Sunny

Not applicable
Author

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