topic Re: transformation in table in QlikView

transformation in table

Mon, 24 Mar 2014 08:33:08 GMT

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 — Mon, 24 Mar 2014 08:44:37 GMT

Hi,

You have to Cross Table load the table.

Hope this helps

Thanks & Regards

jagan — Mon, 24 Mar 2014 09:13:56 GMT

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 — Mon, 24 Mar 2014 10:19:51 GMT

Please find the attached file.