topic Sorting on pivot table in QlikView

Sorting on pivot table

Fri, 15 Jan 2010 10:20:04 GMT

Hi all,

I want make a static sorting on the pivot table as follow. I have 2 dimensions and 1 expression. I want sort the expression from high to low and also sort ascending with period dimension. See example below:

Period 200901 200902 200903 200904 200905 ......
Region
A 1000 10000 100 1000 999
B 50 90 90 800 789
C 1 1 1 1 1

Have anybody experiense with this kind of sorting?

Thanks,
Erol.

Sorting on pivot table

prieper — Sun, 17 Jan 2010 19:15:46 GMT

Go to Properties -> Sort. There you have different possibilities, by "Y"-value, i.e. following the expression, you may also sort alphabetically or by numeric value of them dimension. Another possibility you have under "Expression", where you may formulate your own expression, like
{code]MATCH(Region, 'A', 'C', 'B')

HTH
Peter

Sorting on pivot table

Mon, 18 Jan 2010 13:12:16 GMT

Hi Peter,

Thanks for the solution. On the first dimension i created a sort based on the expression -> AGGR(Sum (Waarde),[Werkorder & omschrijving], Jaar, Maand) The second dimension i sorted numeric ascending on the period. Now i have the result that i wanted.

Regards,
Erol.