Qlikview Pivot table sorting

[Anonymous]

Hello,

I am looking for advise on how to sort the pivot table columns which have merged cells.

Following is an inline table I have created to show the scenario:

COLUMNVIEW:
LOAD * Inline [
ColumnKey, Column, ColumnOrder, ReportKey
1,   VS-DA,     1,   1
2,   VS-DB,     2,   1
3,   VS-B8,     3,   1
4,   VS-DD,     4,   1
5,   VS-HH,     5,   1
6,   VS-DE,     6,   1
7,   VS-DJ,     7,   1
8,   VS-HI,     8,   1
9,   VS-DK,     9,   1
10,  VS-DA,     1,   2
11,  VS-DB,     2,   2
12,  VS-DC,     3,   2
13,  VS-DI,     4,   2
14,  VS-DF,     5,   2
15,  VS-DD,     6,   2
16,  VS-DL,     7,   2
17,  VS-DG,     8,   2
18,  VS-JW,     9,   2
19,  VS-HV,     10,  2
20,  VS-HW,     11,  2
];

I need to sort Pivot table columns by first ReportKey and then by ColumnOrder. I have specified those fields in the Sort tab as expression to use for sort. Still it is not sorting as expected.

Following the screenshot of pivot table:

I am attaching the QVW file which has the above inline table loaded and pivot table objects which I am using it for testing.

Can you please advise on how to make it work ?

Thanks,

Ravi

[antoniotiman]

May be

[HirisH_V7]

Hi ,

At Column Dimension under sort tab,

Uncheck all and Check Numeric -> Ascending.

PFA,

HTH,

Hirish

[Anonymous]

When I Uncheck all and Check Numeric -> Ascending.

It is sorting correctly for the Columns under ReportKey 1.

But for ReportKey 2, VS-DD should be after VS-DF. But it is shown before  VS-DC.

I do not know how to fix this.