Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please check enclosed table showing Customer Name, Customer ID and Date wise data for number of pallets made/dispatched at/from our warehouse. Positive numbers showing pallet made at warehouse and negative numbers showing pallets dispatched to customer from our warehouse.
I want below table in Qlikview.. Kindly provide me code for the same. Also, while loading I can see that date is automatically formated in numbers. How can I get Date instead of numbers while selecting fields in qlikview.
Description | TOTAL | January | February |
Total Pallets Made | 94 | 71 | 23 |
Total Pallets Dispatched | 88 | 34 | 41 |
Hi,
please have a look at script and pivot table expressions in my attached app.
Regards,
Stefan