Qlik Sense Pivot Table Rank by one measure by display another

Wed, 28 Oct 2015 14:44:59 GMT

Hello Everyone,

I'm having a problem sorting my pivot table

In rows:

Chain Name ( Limitation set to :Fixed number Top :5 )

Measures

Columns

Month-Year

Measures

Gross Profit $

Gross Profit %

The problem is that i need to show top 5 based on Net Sales not Gross Profit but user want to see Gross profit displayed in pivot table for top 5 Net Sales (net sales is different measure ) does anyone know how i can solve this problem ?

Thank you !

I'm using Qlik Sense (2.0.3)

Re: Qlik Sense Pivot Table Sort by Expression

Thu, 29 Oct 2015 15:36:08 GMT

In case someone hits the same problem this is how i solved it.

AGGR(IF(Rank(sum(Net_Sales), 4)<=5,Chain Name), Chain Name)

topic Qlik Sense Pivot Table Rank by one measure by display another in App Development

Qlik Sense Pivot Table Rank by one measure by display another

Re: Qlik Sense Pivot Table Sort by Expression