Sorting by expression with no dimension in pivot table

[abhi1490]

Hi qlik community,

I have been looking around for some hint but no luck. I am stuck with a problem in regards to sort data in a pivot table.

I am creating an adhoc waterfall chart where users can select parameters and see calculated results based on their selections. 

I have a pivot table where we do not have a dimension and we have 4 measure. 

These are my formulas 

I want to sort the expression in ascending order or descending order based on the expression value that we get based on the adhoc selections.

I am trying to use the sorting functionality on the the pivot table, flagging the Descending order sorting by expression but with no luck

Any suggestion on how this can be achieved? I will keep looking if there is a work around.

Thank you in advance for your help. 

-Abhishek

[edwin · Accepted solution]

one brute force approach is to use a valuelist() as dimension:

Valuelist('Total Cusromr','Age', 'Postal Code', 'Customer Segment')

in your expression:

pick(match(Valuelist('Total Cusromr','Age', 'Postal Code', 'Customer Segment'),'Total Cusromr','Age', 'Postal Code', 'Customer Segment'),
count(...),
count(...),
count(...),
count(...))

using your expressions

[abhi1490]

Thanks Edwin. That solution worked well.

[edwin]

yw