Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
Rajkumar
Creator
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.

 

Pivot Sorting.PNG

Labels (1)
2 Solutions

Accepted Solutions
agigliotti
Partner
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.

View solution in original post

jupitopino
Partner
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.

View solution in original post

6 Replies
agigliotti
Partner
Partner

do you mean sorting by expression ASC or DESC ?

Rajkumar
Creator
Creator
Author

Yes DESC order.

agigliotti
Partner
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.

View solution in original post

jupitopino
Partner
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.

View solution in original post

Rajkumar
Creator
Creator
Author

It works completely fine.

Only concern is performance because is data is huge.

Any other way ?

 

Rajkumar
Creator
Creator
Author

Hi,

Any Help?