Discussion Board for collaboration on QlikView Scripting.
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
Go to Solution.
Try like this
(ooxml, embedded labels, table is [Default ], filters(
WHERE(REGION <> 'Region of sales');
Thank you very much for your reply.Its working.
Can you please explain in brief what you did.