Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks Edwin. That solution worked well.
yw