CrossTable

[ketanvaria]

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.

[undergrinder]

Hi Ketan,

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.

G.

[vijayaganesh_s]

Hi Ketan,

Give a try while loading your data with the below script

CROSSTABLE("Date",Data)

LOAD <... Statements...>

FROM <Source>;

Thanks