topic Re: Sorting a pivot table - or change to straight table - but how? in QlikView

Sorting a pivot table - or change to straight table - but how?

Mon, 25 Aug 2014 08:56:54 GMT

Hi,

I have to modify an existing pivot table to sort the revenue per customer and month. If I select only one month, it is working:

If I select more than one month, the revenue is not sorted anymore. How can I achieve this (sample app attached)?

So the goal would be to have for the lastest month (201406) the following order

23.070,04

14.003,29

13.433,09

etc,

Thanks.

CELAMBARASAN — Mon, 25 Aug 2014 09:07:47 GMT

I hope 201407 is the latest month

Sort by expression will be

For Latest month =Sum({<Month={$(=Max(Month))}>}Revenue)

For First month =Sum({<Month={$(=Min(Month))}>}Revenue)

Hope this helps

christian77 — Mon, 25 Aug 2014 09:14:05 GMT

Hi.

To sort all the dimensions in a pivot table you can try adding or operating your expressions, and placing them into the sort by expression box.

(sum({LAST YEAR}revenue)/SUM({THIS YEAR} revenue))-1

Even you can weight them multiplying by some factor.

To sort a pivot table by more than one dimension is something difficult.

In you picture, I see there is a missorder in the first column, then do:

sum({THIS YEAR, min(MONTH) }revenue) --> (Simplified sintax)

This may help you.