topic Re: Sort a pivot with 3 dimension in QlikView

Sort a pivot with 3 dimension

filippo — Wed, 22 Feb 2012 20:04:14 GMT

I have a problem with sorting a pivot table:

I have two dimensions on the left and one on the top. One expression with the sum of value.

I want to sort the pivot by decreasing value for the first dimension but if i expand the second dimension is not sort correctly.

Suggestion??

Thans.

I attach a example.

Wed, 22 Feb 2012 23:14:32 GMT

With partial sum for car doesnt change any mor, but I dont know if thats what you want

Fri, 16 Mar 2012 13:49:01 GMT

You can concatenate your dimensions in a column.

You put that column in first so you can sort with this one.

You hide this column with the macro :

sub Collapse

call HideColumn("CH06", 1)

end sub

private sub HideColumn(ch, n)

set ch = ActiveDocument.GetSheetObject(ch)

ch.SetPixWidth (n-1), 0

end sub

but you to stop the posssibility of reduction

Regards,

Cyril