Qlik Community

Qlik Sense App Development

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

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
hermilogayosso
New 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
Honored Contributor

Re: 3 highest prices and the three lowest prices in pivot table

May be try this:

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