# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for
Did you mean:
Creator

## 2 Dimension sorting in pivot table in qlik sense

Hi all,

How to sort 2 dimension in pivot table  ?

Please find the sample file attached.

Labels (1)
• ### sorting in pivot

2 Solutions

Accepted Solutions
Partner

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.

Partner

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.

6 Replies
Partner

do you mean sorting by expression ASC or DESC ?

Creator
Author

Yes DESC order.

Partner

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.

Partner

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.

Creator
Author

It works completely fine.

Only concern is performance because is data is huge.

Any other way ?

Creator
Author

Hi,

Any Help?