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: 
hermilogayosso
Contributor
Contributor

3 highest prices and the three lowest prices in pivot table

Hello, I am looking to create a pivot table in which you can visualize the 3 highest prices and the three lowest prices by product category, by city and by area.

The table should look like this:

Sin título.png

the data in green are the highest prices in that category, in red the lowest prices

thanks for your help!!!

1 Reply
balabhaskarqlik

May be try this:

=aggr(if(rank(sum(Prices))<=3 or rank(-sum(Prices))<=3,[Product Category]),City,Area)