Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
MVP
MVP

Re: Monthwise Data Needed

Hi,

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

Regards,

Stefan

Community Browser