topic Re: Calculate Aggregate Functions in Pivot Tables in QlikView https://community.qlik.com/t5/QlikView/Calculate-Aggregate-Functions-in-Pivot-Tables/m-p/96982#M15560 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; I have attached the Application based on your requirement.Please check it.</P></BODY></HTML> Fri, 26 Oct 2018 09:58:29 GMT thannila 2018-10-26T09:58:29Z Calculate Aggregate Functions in Pivot Tables https://community.qlik.com/t5/QlikView/Calculate-Aggregate-Functions-in-Pivot-Tables/m-p/96979#M15557 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I am facing difficulty in creating pivot chart in qlikview. To manage calculations and dimension is a big&nbsp; issue.</P><P></P><P>I have attached the excel sheet. It has sample data in first sheet&nbsp; and the next sheet has targeted dashboard. Can some one please help ?</P><P></P><P>Many Thanks</P><P></P><P>Kind Regards</P><P>Waqas Shah</P></BODY></HTML> Thu, 11 Oct 2018 14:10:26 GMT https://community.qlik.com/t5/QlikView/Calculate-Aggregate-Functions-in-Pivot-Tables/m-p/96979#M15557 waqasshah 2018-10-11T14:10:26Z Re: Calculate Aggregate Functions in Pivot Tables https://community.qlik.com/t5/QlikView/Calculate-Aggregate-Functions-in-Pivot-Tables/m-p/96980#M15558 <HTML><HEAD></HEAD><BODY><P>Maybe somehow&nbsp; like this</P></BODY></HTML> Thu, 25 Oct 2018 04:00:19 GMT https://community.qlik.com/t5/QlikView/Calculate-Aggregate-Functions-in-Pivot-Tables/m-p/96980#M15558 andrey_krylov 2018-10-25T04:00:19Z Re: Calculate Aggregate Functions in Pivot Tables https://community.qlik.com/t5/QlikView/Calculate-Aggregate-Functions-in-Pivot-Tables/m-p/96981#M15559 <HTML><HEAD></HEAD><BODY><P>Dear Andrey,</P><P></P><P>Thanks for your try but I would like to hide the column when there is no data or zero values. Like in your QVW file last column <STRONG>"2016/2017 change from previous year %"</STRONG> has zero value. I want this column to be hidden.</P><P></P><P>Can you hide it ?</P><P></P><P>Kind Regards</P><P>Waqas Shah</P></BODY></HTML> Fri, 26 Oct 2018 09:04:27 GMT https://community.qlik.com/t5/QlikView/Calculate-Aggregate-Functions-in-Pivot-Tables/m-p/96981#M15559 waqasshah 2018-10-26T09:04:27Z Re: Calculate Aggregate Functions in Pivot Tables https://community.qlik.com/t5/QlikView/Calculate-Aggregate-Functions-in-Pivot-Tables/m-p/96982#M15560 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; I have attached the Application based on your requirement.Please check it.</P></BODY></HTML> Fri, 26 Oct 2018 09:58:29 GMT https://community.qlik.com/t5/QlikView/Calculate-Aggregate-Functions-in-Pivot-Tables/m-p/96982#M15560 thannila 2018-10-26T09:58:29Z Re: Calculate Aggregate Functions in Pivot Tables https://community.qlik.com/t5/QlikView/Calculate-Aggregate-Functions-in-Pivot-Tables/m-p/96983#M15561 <HTML><HEAD></HEAD><BODY><P>I'm not sure, but maybe this</P></BODY></HTML> Fri, 26 Oct 2018 10:00:08 GMT https://community.qlik.com/t5/QlikView/Calculate-Aggregate-Functions-in-Pivot-Tables/m-p/96983#M15561 andrey_krylov 2018-10-26T10:00:08Z Re: Calculate Aggregate Functions in Pivot Tables https://community.qlik.com/t5/QlikView/Calculate-Aggregate-Functions-in-Pivot-Tables/m-p/96984#M15562 <HTML><HEAD></HEAD><BODY><P>Sorry I have qlikview only not Qlik sense... can you please semd me qvw file?</P></BODY></HTML> Fri, 26 Oct 2018 11:30:38 GMT https://community.qlik.com/t5/QlikView/Calculate-Aggregate-Functions-in-Pivot-Tables/m-p/96984#M15562 waqasshah 2018-10-26T11:30:38Z