topic Re: Sorting by expression with no dimension in pivot table in QlikView

Sorting by expression with no dimension in pivot table

abhi1490 — Fri, 05 Mar 2021 15:04:17 GMT

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

Re: Sorting by expression with no dimension in pivot table

edwin — Sun, 07 Mar 2021 17:47:57 GMT

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

Re: Sorting by expression with no dimension in pivot table

abhi1490 — Mon, 08 Mar 2021 06:46:58 GMT

Thanks Edwin. That solution worked well.

Re: Sorting by expression with no dimension in pivot table

edwin — Mon, 08 Mar 2021 14:52:17 GMT