Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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