Discussion board where members can get started with QlikView.
I am new on Qlikview so accept my apologizes if my question is too easy.
in a loading script I am loading a table like the one below:
I would like to create in the script a table from the one above to look like the one below:
Would you know how to do that?
Go to Solution.
Take a look here. Cross table instruction will help you
The Crosstable Load
tmp: CrossTable(Year, [Est Cost]) LOAD * Inline [ Project,Est Cost 2017,Est Cost 2018,Est Cost 2019,Est Cost 2020 Proj 1,100,50,80,80 Proj 2,120,100,70,50 Proj 3,90,90,, Proj 4,,,10,1 ]; NoConcatenate SUMARY: LOAD Project, [Est Cost], Right(Year,4) as Year Resident tmp Where [Est Cost]>0 ; DROP Table tmp;
You could also use Pivot chart directly and get this result.
Kindly find attached QV document in which i did same.
Thank you very much, it works great.
Thank you very much for your help, this is ,perfect.