topic Proper format. in QlikView

Proper format.

jsingh71 — Sun, 25 Aug 2013 14:57:28 GMT

Hi All,

I have one sales table in following format:

I want to load data in qlikview in below format

How can I achieve this? I tried cross table load but didn't got the proper result. Please help

jagan — Sun, 25 Aug 2013 15:08:10 GMT

Hi,

Try like this

Test:

LOAD SALES_DATE,

SALES_PERSON,

REGION,

SALES

FROM

(ooxml, embedded labels, table is [Default ], filters(

Transpose()

))

WHERE(REGION <> 'Region of sales');

Regards,

Jagan.

jsingh71 — Sun, 25 Aug 2013 16:37:13 GMT

Hi Jagan,

Thank you very much for your reply.Its working.

Can you please explain in brief what you did.

Thanks.