Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

i have some item ids and spend, i want to sort top 3 items based on sum spend, How can we do that in pivot table

i have some item ids and spend, i want to sort top 3 items based on sum spend, How can we do that in pivot table

4 Replies
shraddha_g
Not applicable

Re: i have some item ids and spend, i want to sort top 3 items based on sum spend, How can we do that in pivot table

In Dimension - there is a Property called Limitation with default value as No limitation. Change it to Fixed Number - Select top and enter 3 in Text Box

Not applicable

Re: i have some item ids and spend, i want to sort top 3 items based on sum spend, How can we do that in pivot table

i am able sort top 3 items but they are sorting in unusual manner. 1st spend coming in 2nd place 3rd item in 1st place, i want those item on the basis of spend , i mean 1 st item should be top spend item....Thanks in advance...

Chanty4u
Not applicable

Re: i have some item ids and spend, i want to sort top 3 items based on sum spend, How can we do that in pivot table

put an condition

=match(Field,'first','second','third')

Not applicable

Re: i have some item ids and spend, i want to sort top 3 items based on sum spend, How can we do that in pivot table

Suppose if i have million IDs, should i write all IDs?