issues with sorting pivot tables

diffeyj — Fri, 19 Aug 2011 02:17:09 GMT

Hi All,

I have a pivot table that shows customers and their sales.

It has 3 dimensions, customer code, customer name and calendar month. The calendar month has been pivoted so it goes across the page.

I want to be able to have the user sort this table by either customer code or customer name, in either ascending or descending order. I have got a macro that works a treat for the customer code (as it is the first dimension), but I can't get it to sort by the 2nd column. I assumed this was because it was a pivot table, so I am trying to sort column 1 using an expression, but just can't get it to work.

So in the customer code sort area I have only got sort by expression ticked, and I have tried a couple of expressions (which if I add as an expression within the table it shows me the result I am after, it just wont sort on it). The one I found that looked like it should have worked was: pick(1,customerName)

Has anyone got any suggestions?

Kind Regards

Josh

issues with sorting pivot tables

kaushalview — Fri, 19 Aug 2011 04:20:02 GMT

Its difficult to sort in Pivot table.Use straight table for better sorting as per your requirment.

Regards

Kaushal Mehta

topic issues with sorting pivot tables in QlikView

issues with sorting pivot tables

issues with sorting pivot tables