Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)