Cross table transformation

[nishanthi_8]

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]

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]

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