transformation in table

[#1]

hey guys!!

i am pretty new to qlikview. i wanted to know if a certain table can be viewed as showed in this excel file in qlikview??

[its_anandrjs]

Hi,

You have to Cross Table load the table.

Hope this helps

Thanks & Regards

[jagan]

Hi,

Try this

CrossTable(Location, Value, 2)

LOAD Location AS ProductNumber,

     F2 as ProductName,

     AP,

     MP,

     UP,

     Kerala,

     Delhi

FROM

[\\fab2crp-nas1\home18\RC100990\Profile\Desktop\temp.xls]

(biff, embedded labels, header is 1 lines, table is [Sheet1$], filters(

Transpose(),

Replace(1, top, StrCnd(null))

));

Regards,

Jagan.

[arsal_90]

Hi

Please find the attached file.