Need help on cross tab

[#1]

Hi

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 !!

[MK_QSL · Accepted solution]

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);

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

[#3]

Hey Manish,

Super thanks !! Works perfectly for my requirement