Customers down the side and sales by month across the top.
Data file has 3 fields: 1. Customer
2. Date (yyyymmdd) ; Might be able to provide date in ISO format.
Create a Pivot Table..
Month //If Month is not there, you can create from Date Field in the script itself..
Now you can adjust the Month to the Top of the pivot table by drag and drop
Very new to Qlikview.
How are fields created in the script (or elsewhere)?
Need simple examples.
Date is in "YYYYMMDD" format (not ISO format).
Date(Date#(DateField,'YYYYMMDD')) as DateField,
Month(Date#(DateField,'YYYYMMDD')) as Month,
Hope this will help..
if you got answer, close the thread by selecting correct answer.
Retrieving data ...