topic QlikView - sorting pivot table problem in QlikView

QlikView - sorting pivot table problem

marioxp — Thu, 24 Oct 2019 07:29:54 GMT

Hi,
I have a problem sorting in the pivot table, when I sort the first level, I can't sort the second level anymore.
Can you tell me how to make it sort time for date and for user?

Re: QlikView - sorting pivot table problem

olivierrobin — Thu, 24 Oct 2019 15:32:12 GMT

hello

what do you have for each dimension in sort folder of your char properties ?

for each dimension, you may have to code a formula to sort according to your needs

Re: QlikView - sorting pivot table problem

marcus_sommer — Fri, 25 Oct 2019 14:37:44 GMT

See: Perfectly-Sorting-Pivot-Table-by-A-Z-y-Value-set-for-each-dim.

- Marcus