Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
qliknexus_kgcru
Partner - Contributor III
Partner - Contributor III

Add a Quarter total

Hi All,

I have this table below which is based on fiscal year:

table1.png

I need to have add a total per quarter e.g. OCT NOV DEC 3Q JAN FEB MAR 4Q.... the total quarter's value should be the sum of all the months in the quarter. The values for each month of the rows and columns are calculated individually using set analysis.

how can i achieve this without editing data load? thank you very much.

1 Reply
qliksus
Specialist II
Specialist II

Just add the field Quarter as a dimension and check "Show Partial Sum" under presentation for the Quarter field