How to create a "cross table" type of customer chart with sales by month.

[#1]

  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.

                                  3.   $Sales. 

[MK_QSL]

Create a Pivot Table..

Dimension

Customer

Month     //If Month is not there, you can create from Date Field in the script itself..

Expression

SUM(Sales)

Now you can adjust the Month to the Top of the pivot table by drag and drop

[#3]

Very new to Qlikview.

How are fields created in the script (or elsewhere)?

Need simple examples.

Date is in  "YYYYMMDD"  format  (not  ISO format).

Thank you.

[MK_QSL]

Sales:
Load

Customer,

Date(Date#(DateField,'YYYYMMDD')) as DateField,

Month(Date#(DateField,'YYYYMMDD')) as Month,

Sales

From TableName;

Hope this will help..

[#5]

Thank you.

[MK_QSL · Accepted solution]

if you got answer, close the thread by selecting correct answer.