Qlik Community

Qlik Sense App Development

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

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)