topic Cross table transformation in QlikView

Cross table transformation

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

LOAD ID,

DATE,

CUM_DATE,

KPI_NAME,

DIFFERENCE_VALUE,

MAX_VALUE,

MIN_VALUE

FROM

[path]

how to transform form kpi name upto min values in the form of columns using cross table?

Anonymous — Wed, 05 Apr 2017 04:52:39 GMT

Crosstable (<columnname>,<valuecolumn name>,2)

LOAD ID,

DATE,

CUM_DATE,

KPI_NAME,

DIFFERENCE_VALUE,

MAX_VALUE,

MIN_VALUE

FROM

[path].

2 is the number you specify to say qlikview to keep those number of columns and start pivoting.

rahulpawarb — Wed, 05 Apr 2017 05:38:18 GMT

Hello Nishanthi,

Please refer below sample script:

Table:

CrossTable(KPI_NAME, KPI_VALUE, 3)

LOAD ID,

DATE,

CUM_DATE,

KPI_NAME,

DIFFERENCE_VALUE,

MAX_VALUE,

MIN_VALUE

FROM

[path]

Hope this will be of help.

Regards!

Rahul