Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Monthwise Data Needed

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.

DescriptionTOTALJanuaryFebruary
Total Pallets Made947123
Total Pallets Dispatched883441
1 Reply
swuehl
MVP
MVP

Hi,

please have a look at script and pivot table expressions in my attached app.

Regards,

Stefan