Individual Totals for all Quarters in a Table

[praveen1108]

Hello All,

I would like to create a table in qliksense like below. Please suggest me if it is possible.If yes, How?

Customer Name     Q1-2018 Q2-2018 Q3-2018 Q4 2018 CY 2018 Q1-2019 Q2-2019 Q3-2019 Q4 2019 CY 2019

X                                     2                 3               1                  2               8              1              0               0                  1                2

Regards,

Praveen

[shiveshsingh]

Can you share sample data?

[Anil_Babu_Samineni]

Create field in script like

Load Customer_Name, DateField, Sales,  'Q' & Ceil(Month(DateField) / 3) & '-' & Year(DateField) AS Quarter_Year From table;

Then, create Pivot table with dimension as Customer_Name, Quarter_Year with expression Sum(Measure) and drag second dimension to drag.

[praveen1108]

Hi, Please find the attached sample data and required output in excel.Thanks!

[praveen1108]

Hey, Did you get a chance to look into the data?

[shiveshsingh]

Expression - Sum(Sales)

Dimension - Customer, Quarter

Take on Pivot table and drag Quarter Column to look as present in screenshot.

Sort - Based on numeric Quarter.