topic Scripting sum of months in QlikView https://community.qlik.com/t5/QlikView/Scripting-sum-of-months/m-p/682202#M675938 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">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 <SPAN style="color: #0000ff;">sum</SPAN>({<SPAN style="color: #800000;">Month</SPAN></SPAN><SPAN style="font-size: 12pt;">='Jan''Feb''Mar') - How do I sum the months up for a quarter value.&nbsp; I need this for each quarter of the year.</SPAN></P></BODY></HTML> Tue, 15 Jul 2014 21:33:18 GMT 2014-07-15T21:33:18Z Scripting sum of months https://community.qlik.com/t5/QlikView/Scripting-sum-of-months/m-p/682202#M675938 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">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 <SPAN style="color: #0000ff;">sum</SPAN>({<SPAN style="color: #800000;">Month</SPAN></SPAN><SPAN style="font-size: 12pt;">='Jan''Feb''Mar') - How do I sum the months up for a quarter value.&nbsp; I need this for each quarter of the year.</SPAN></P></BODY></HTML> Tue, 15 Jul 2014 21:33:18 GMT https://community.qlik.com/t5/QlikView/Scripting-sum-of-months/m-p/682202#M675938 2014-07-15T21:33:18Z Re: Scripting sum of months https://community.qlik.com/t5/QlikView/Scripting-sum-of-months/m-p/682203#M675939 <HTML><HEAD></HEAD><BODY><P>maybe you need a calculated dimension for quarter</P><P></P><P>='Quarter ' &amp; ceil(Month/3)</P></BODY></HTML> Tue, 15 Jul 2014 21:38:06 GMT https://community.qlik.com/t5/QlikView/Scripting-sum-of-months/m-p/682203#M675939 maxgro 2014-07-15T21:38:06Z