2 Dimension sorting in pivot table in qlik sense

[Rajkumar]

Hi all,

How to sort 2 dimension in pivot table  ?

Please find the sample file attached.

[agigliotti]

do you mean sorting by expression ASC or DESC ?

[Rajkumar]

Yes DESC order.

[agigliotti · Accepted solution]

make the second dimension as a calculated dimension as below:

=aggr( dual(STORES, SUM(SALES)), QUARTER, STORES)

on Sorting:

Sort numerically DESC

I hope it can helps.

[jupitopino · Accepted solution]

Hi Rajkimar.

Try this...

Create a new Dimension  Stores_v2 = Dual(STORES, Aggr(Sum(SALES), QUARTER, STORES))

And Sort this, by expresion  SUM(SALES).

Is the same that this old post... https://community.qlik.com/t5/Qlik-Sense-App-Development/Order-pivot-table-by-expression/m-p/1456741...

mark complete if is fine!

Regards.

[Rajkumar]

It works completely fine.

Only concern is performance because is data is huge.

Any other way ?

[Rajkumar]

Hi,

Any Help?

[_Julia_]

Thank you! That's brilliant!