Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
praveen1108
Contributor

Individual Totals for all Quarters in a Table

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

Labels (1)
5 Replies
shiveshsingh
Honored Contributor

Re: Individual Totals for all Quarters in a Table

Can you share sample data?

Re: Individual Totals for all Quarters in a Table

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.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
praveen1108
Contributor

Re: Individual Totals for all Quarters in a Table

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

praveen1108
Contributor

Re: Individual Totals for all Quarters in a Table

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

Highlighted
shiveshsingh
Honored Contributor

Re: Individual Totals for all Quarters in a Table

 

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.Capture.PNG