Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
ketanvaria
New Contributor III

CrossTable

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.

2 Replies
undergrinder
Valued Contributor II

Re: CrossTable

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.

Partner
Partner

Re: CrossTable

Hi Ketan,


Give a try while loading your data with the below script


CROSSTABLE("Date",Data)

LOAD <... Statements...>

FROM <Source>;


Thanks