Qlikview Pivot table sorting

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Qlikview Pivot table sorting

antoniotiman — Fri, 27 Oct 2017 07:20:35 GMT

May be

Re: Qlikview Pivot table sorting

HirisH_V7 — Fri, 27 Oct 2017 09:39:18 GMT

Hi ,

At Column Dimension under sort tab,

Uncheck all and Check Numeric -> Ascending.

PFA,

HTH,

Hirish

Re: Qlikview Pivot table sorting

Anonymous — Fri, 27 Oct 2017 13:38:51 GMT

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.

topic Qlikview Pivot table sorting in QlikView

Qlikview Pivot table sorting

Re: Qlikview Pivot table sorting

Re: Qlikview Pivot table sorting

Re: Qlikview Pivot table sorting