Discussion board where members can get started with Qlik Sense.
I have a sample file here which I need to make into a crosstable in Qlik on loading. (The command for this is transpose in excel).
I don't want the additional step of transpose in excel before loading. Is their something simple I can do in Qlik when I upload (I am a newby and not familiar with scripts!)
Sample table in excel attached.
look into the attached qvf.
there are some ugly things in it (format the excel date with dictionary), but it can manageable when the data is monthly.
Give a try while loading your data with the below script
LOAD <... Statements...>