topic Re: Need help on cross tab in QlikView

Need help on cross tab

Tue, 29 Apr 2014 09:43:35 GMT

I have attached an excel file....On the top is the source format,which is in sharepoint, I have imported that to Qlikview...below is how the presentation should be..I`m using crosstab to get the desired format..but somehow I`m not able to..

Request to suggest some solutions for the same.

Please help..

Thanks !!

Re: Need help on cross tab

MK_QSL — Tue, 29 Apr 2014 09:53:50 GMT

Try below in your script...

===========

TEABLE:

CrossTable(Tech, [Technology Level], 4)

LOAD [Emp ID],

[Emp Name],

Manager,

IF([Technology-1] = 'Others', [Technology-1-Specify], [Technology-1]) as Technology,

[Technology-Level-1]

FROM

MMM.xlsx

(ooxml, embedded labels, table is Sheet1);

CrossTable(Tech, [Technology Level], 4)

LOAD [Emp ID],

[Emp Name],

Manager,

IF([Technology-2] = 'Others', [Technology-2-Specify], [Technology-2]) as Technology,

[Technology-Level-2]

FROM

MMM.xlsx

(ooxml, embedded labels, table is Sheet1);

CrossTable(Tech, [Technology Level], 4)

LOAD [Emp ID],

[Emp Name],

Manager,

IF([Technology-3] = 'Others', [Technology-3-Specify], [Technology-3]) as Technology,

[Technology-Level-3]

FROM

MMM.xlsx

(ooxml, embedded labels, table is Sheet1);

=============================

Re: Need help on cross tab

Tue, 29 Apr 2014 10:35:23 GMT

Hey Manish,

Super thanks !! Works perfectly for my requirement