Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

  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. 

Tags (1)
1 Solution

Accepted Solutions

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

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

5 Replies

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

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

Not applicable

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

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.

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

Sales:
Load

Customer,

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

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

Sales

From TableName;


Hope this will help..

Not applicable

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

Thank you.

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

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

Community Browser