topic Re: Customisation of the Totals in a chart in App Development https://community.qlik.com/t5/App-Development/Customisation-of-the-Totals-in-a-chart/m-p/8692#M676 <HTML><HEAD></HEAD><BODY><P>Hi Jose,</P><P>For example, I am trying to display orders, backlog, etc in the pivot table which belong to one column. Under that I have to show the current year and prior year count. Now the total formula for Orders is different from the Backlog.</P><P></P><P>I want to customise the formula only for totals. Let me know in case you need anything else. Thank you</P><P></P><P>Regards</P><P>Santhosh Kasam</P></BODY></HTML> Thu, 10 May 2018 10:10:03 GMT santhoshkasam09 2018-05-10T10:10:03Z Customisation of the Totals in a chart https://community.qlik.com/t5/App-Development/Customisation-of-the-Totals-in-a-chart/m-p/8689#M673 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a requirement where the totals of the chart is not usual. In a pivot table, based on the column value, the total display should change.</P><P></P><P>Is there any way to achieve this? Thank you.</P><P></P><P>Regards</P><P>Santhosh Kasam</P></BODY></HTML> Wed, 09 May 2018 11:55:27 GMT https://community.qlik.com/t5/App-Development/Customisation-of-the-Totals-in-a-chart/m-p/8689#M673 santhoshkasam09 2018-05-09T11:55:27Z Re: Customisation of the Totals in a chart https://community.qlik.com/t5/App-Development/Customisation-of-the-Totals-in-a-chart/m-p/8690#M674 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Could you explain better your question? I don´t understand what are you trying to say.</P><P></P><P>Regards.</P></BODY></HTML> Wed, 09 May 2018 14:27:21 GMT https://community.qlik.com/t5/App-Development/Customisation-of-the-Totals-in-a-chart/m-p/8690#M674 jmvilaplanap 2018-05-09T14:27:21Z Re: Customisation of the Totals in a chart https://community.qlik.com/t5/App-Development/Customisation-of-the-Totals-in-a-chart/m-p/8691#M675 <HTML><HEAD></HEAD><BODY><P>You can use the Dimensionality() function. Here you have more information:</P><P></P><P><A href="https://community.qlik.com/docs/DOC-7969">How to use - Dimensionality()</A></P></BODY></HTML> Wed, 09 May 2018 14:29:23 GMT https://community.qlik.com/t5/App-Development/Customisation-of-the-Totals-in-a-chart/m-p/8691#M675 jaumecf23 2018-05-09T14:29:23Z Re: Customisation of the Totals in a chart https://community.qlik.com/t5/App-Development/Customisation-of-the-Totals-in-a-chart/m-p/8692#M676 <HTML><HEAD></HEAD><BODY><P>Hi Jose,</P><P>For example, I am trying to display orders, backlog, etc in the pivot table which belong to one column. Under that I have to show the current year and prior year count. Now the total formula for Orders is different from the Backlog.</P><P></P><P>I want to customise the formula only for totals. Let me know in case you need anything else. Thank you</P><P></P><P>Regards</P><P>Santhosh Kasam</P></BODY></HTML> Thu, 10 May 2018 10:10:03 GMT https://community.qlik.com/t5/App-Development/Customisation-of-the-Totals-in-a-chart/m-p/8692#M676 santhoshkasam09 2018-05-10T10:10:03Z Re: Customisation of the Totals in a chart https://community.qlik.com/t5/App-Development/Customisation-of-the-Totals-in-a-chart/m-p/8693#M677 <HTML><HEAD></HEAD><BODY><P>Hi Jaume,</P><P></P><P>This worked. Thanks for your response <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Regards</P><P>Santhosh Kasam</P></BODY></HTML> Thu, 10 May 2018 10:10:55 GMT https://community.qlik.com/t5/App-Development/Customisation-of-the-Totals-in-a-chart/m-p/8693#M677 santhoshkasam09 2018-05-10T10:10:55Z