Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jsingh71
Valued Contributor

Proper format.

Hi All,

I have one sales table in following format:

SALES_DATEDate of sales12/27/201112/27/201112/27/201112/27/201112/27/20113/25/20123/25/20123/25/2012
SALES_PERSONEmployee's last nameTHOMPSONLEEBROWNLEEGOUNOTTHOMPSONTHOMPSONLEE
REGIONRegion of salesOntario-SouthOntario-SouthQuebecManitobaQuebecOntario-SouthQuebecOntario-South
SALESNumber of sales13121312

I want to load data in qlikview in below format

Date of salesEmployee's last nameRegion of salesNumber of sales
12/27/2011THOMPSONOntario-South1
12/27/2011LEEOntario-South3
12/27/2011BROWNQuebec1

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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Proper format.

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.

2 Replies
Highlighted
MVP
MVP

Re: Proper format.

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
Valued Contributor

Re: Proper format.

Hi Jagan,

Thank you very much for your reply.Its working.

Can you please explain in brief what you did.

Thanks.

Community Browser