Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Hi Jagan,
Thank you very much for your reply.Its working.
Can you please explain in brief what you did.
Thanks.