Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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