Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Scripting sum of months

I did a crosstable and my months fall under the variable Months, but now I need to sum the of each month for a quarter value. Something to the extend of sum({Month='Jan''Feb''Mar') - How do I sum the months up for a quarter value.  I need this for each quarter of the year.

1 Reply
maxgro
MVP
MVP

maybe you need a calculated dimension for quarter

='Quarter ' & ceil(Month/3)