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: 
jduluc12
Creator
Creator

AGGR and identifier

Hi,

I have one expression to show top 5 items.

= concat( if(aggr(rank(sum(Sales)), Item) <=5, Item),   chr(10),   aggr(rank(sum(sales)), Item)  )

I want to use 1 identifier to it always works on full data set and do not get impacted by any selection.

I tried

concat( if(aggr(rank(sum({1}Sales)), Item) <=5, Item),   chr(10),   aggr(rank(sum({1}sales)), Item)  )

but it dos not work.

How to do that?

Regards,

Jean

1 Solution

Accepted Solutions
its_anandrjs

Try this also



concat({1} if(aggr(rank(sum({1}Sales)), Item) <=5, Item),  chr(10),  aggr(rank(sum({1}sales)), Item)  )


Or

concat({1} if(aggr(rank(sum({1} Sales)), Item) <=5, Item),  chr(10),  aggr(rank(sum({1} sales)), Item)  )



Regards

Anand

View solution in original post

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Try this.

concat({1} if(aggr(rank(sum(Sales)), Item) <=5, Item),   chr(10),   aggr(rank(sum(sales)), Item)  )


Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
its_anandrjs

Try this also



concat({1} if(aggr(rank(sum({1}Sales)), Item) <=5, Item),  chr(10),  aggr(rank(sum({1}sales)), Item)  )


Or

concat({1} if(aggr(rank(sum({1} Sales)), Item) <=5, Item),  chr(10),  aggr(rank(sum({1} sales)), Item)  )



Regards

Anand