Proper format.

[jsingh71]

Hi All,

I have one sales table in following format:

SALES_DATE	Date of sales	12/27/2011	12/27/2011	12/27/2011	12/27/2011	12/27/2011	3/25/2012	3/25/2012	3/25/2012
SALES_PERSON	Employee's last name	THOMPSON	LEE	BROWN	LEE	GOUNOT	THOMPSON	THOMPSON	LEE
REGION	Region of sales	Ontario-South	Ontario-South	Quebec	Manitoba	Quebec	Ontario-South	Quebec	Ontario-South
SALES	Number of sales	1	3	1	2	1	3	1	2

I want to load data in qlikview in below format

Date of sales	Employee's last name	Region of sales	Number of sales
12/27/2011	THOMPSON	Ontario-South	1
12/27/2011	LEE	Ontario-South	3
12/27/2011	BROWN	Quebec	1

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

[jagan · Accepted solution]

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]

Hi Jagan,

Thank you very much for your reply.Its working.

Can you please explain in brief what you did.

Thanks.