topic Add a Quarter total in QlikView https://community.qlik.com/t5/QlikView/Add-a-Quarter-total/m-p/115486#M17786 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have this table below which is based on fiscal year:</P><P><IMG alt="table1.png" class="jive-image image-1" height="109" src="https://community.qlik.com/legacyfs/online/208534_table1.png" style="height: 108.901px; width: 951px;" width="951" /></P><P></P><P>I need to have add a total per quarter e.g. OCT NOV DEC <STRONG>3Q </STRONG>JAN FEB MAR <STRONG>4Q.... </STRONG>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. </P><P></P><P>how can i achieve this without editing data load? thank you very much.</P></BODY></HTML> Mon, 23 Jul 2018 09:43:01 GMT qliknexus_kgcru 2018-07-23T09:43:01Z Add a Quarter total https://community.qlik.com/t5/QlikView/Add-a-Quarter-total/m-p/115486#M17786 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have this table below which is based on fiscal year:</P><P><IMG alt="table1.png" class="jive-image image-1" height="109" src="https://community.qlik.com/legacyfs/online/208534_table1.png" style="height: 108.901px; width: 951px;" width="951" /></P><P></P><P>I need to have add a total per quarter e.g. OCT NOV DEC <STRONG>3Q </STRONG>JAN FEB MAR <STRONG>4Q.... </STRONG>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. </P><P></P><P>how can i achieve this without editing data load? thank you very much.</P></BODY></HTML> Mon, 23 Jul 2018 09:43:01 GMT https://community.qlik.com/t5/QlikView/Add-a-Quarter-total/m-p/115486#M17786 qliknexus_kgcru 2018-07-23T09:43:01Z Re: Add a Quarter total https://community.qlik.com/t5/QlikView/Add-a-Quarter-total/m-p/115487#M17787 <HTML><HEAD></HEAD><BODY><P>Just add the field Quarter as a dimension and check "Show Partial Sum" under presentation for the Quarter field </P></BODY></HTML> Mon, 23 Jul 2018 09:55:05 GMT https://community.qlik.com/t5/QlikView/Add-a-Quarter-total/m-p/115487#M17787 qliksus 2018-07-23T09:55:05Z