topic Re: Sort records using expression in pivot table in QlikView

Sort records using expression in pivot table

Tue, 18 Apr 2017 13:00:31 GMT

Hi,

I'm using a pivot table that contains two dimensions and i want to sort records in descending mode. I'm using expression but it is not working to all records.

Here you are images containing the expression.

Re: Sort records using expression in pivot table

vinieme12 — Tue, 18 Apr 2017 13:05:48 GMT

apply the same to the second dimension and try

, This can be tricky at times...so try to sort by Ascending once to see if it does the trick

Re: Sort records using expression in pivot table

neelamsaroha157 — Tue, 18 Apr 2017 13:06:50 GMT

It would be great if you can share some sample data to play with.

Re: Sort records using expression in pivot table

Tue, 18 Apr 2017 13:07:25 GMT

I just apply the same expression to all dimensions and it doesn't work correctly.

Re: Sort records using expression in pivot table

awhitfield — Tue, 18 Apr 2017 13:34:36 GMT

Or even better, a sample qvw?

Andy

Re: Sort records using expression in pivot table

Tue, 18 Apr 2017 13:45:01 GMT

I can't to share de qvw because is confidencial information but supose that you have the next structure:

Category Sub-Category Product TotalSales

Aqua Li Product 1 20,000.00

Aqua ML Product 2 10,000.00

Aqua LI Product 3 5,000.00

Aqua LI Product 4 15,000.00

Aqua ML Product 4 4,000.00

for ML sub-category it sort correctly but to LI sub-category doesn't work correctly.