topic Re: Unable to multiply variables/get totals in pivot charts in App Development https://community.qlik.com/t5/App-Development/Unable-to-multiply-variables-get-totals-in-pivot-charts/m-p/75430#M5008 <HTML><HEAD></HEAD><BODY><P>Which tab am I looking at?</P></BODY></HTML> Fri, 08 Jun 2018 16:46:54 GMT sunny_talwar 2018-06-08T16:46:54Z Unable to multiply variables/get totals in pivot charts https://community.qlik.com/t5/App-Development/Unable-to-multiply-variables-get-totals-in-pivot-charts/m-p/75425#M5003 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm trying to run a simple what-if analysis (see my attached sheet).</P><P></P><P>I'm quite new in Qlik Sense and I can't figure out why I don't get totals in my pivot tables. I'm working with variables and can send the qvf file if needed.</P><P></P><P>Also I'm simply trying to get the new revenue in the box at the bottom of the sheet but this expression does not work (however each variable works individually): </P><P></P><P>sum($(vNewPrice)*$(vNewQty))</P><P></P><P>I would really appreciate your help!</P><P></P><P>Thanks!!!</P></BODY></HTML> Fri, 08 Jun 2018 09:38:01 GMT https://community.qlik.com/t5/App-Development/Unable-to-multiply-variables-get-totals-in-pivot-charts/m-p/75425#M5003 Anonymous 2018-06-08T09:38:01Z Re: Unable to multiply variables/get totals in pivot charts https://community.qlik.com/t5/App-Development/Unable-to-multiply-variables-get-totals-in-pivot-charts/m-p/75426#M5004 <HTML><HEAD></HEAD><BODY><P>Do you have expressions behind these variables or just fields?</P></BODY></HTML> Fri, 08 Jun 2018 15:33:24 GMT https://community.qlik.com/t5/App-Development/Unable-to-multiply-variables-get-totals-in-pivot-charts/m-p/75426#M5004 sunny_talwar 2018-06-08T15:33:24Z Re: Unable to multiply variables/get totals in pivot charts https://community.qlik.com/t5/App-Development/Unable-to-multiply-variables-get-totals-in-pivot-charts/m-p/75427#M5005 <HTML><HEAD></HEAD><BODY><P>I've figured this out using an aggr expression.</P><P></P><P>Althought, I'm still confused with my input variables that won't work in my pivot table (QVF attached).</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 08 Jun 2018 16:04:07 GMT https://community.qlik.com/t5/App-Development/Unable-to-multiply-variables-get-totals-in-pivot-charts/m-p/75427#M5005 Anonymous 2018-06-08T16:04:07Z Re: Unable to multiply variables/get totals in pivot charts https://community.qlik.com/t5/App-Development/Unable-to-multiply-variables-get-totals-in-pivot-charts/m-p/75428#M5006 <HTML><HEAD></HEAD><BODY><P>Check this</P><P><A href="https://community.qlik.com/docs/DOC-16454">Uploading a Sample</A></P></BODY></HTML> Fri, 08 Jun 2018 16:05:46 GMT https://community.qlik.com/t5/App-Development/Unable-to-multiply-variables-get-totals-in-pivot-charts/m-p/75428#M5006 sunny_talwar 2018-06-08T16:05:46Z Re: Unable to multiply variables/get totals in pivot charts https://community.qlik.com/t5/App-Development/Unable-to-multiply-variables-get-totals-in-pivot-charts/m-p/75429#M5007 <HTML><HEAD></HEAD><BODY><P>That was quick! See above.</P></BODY></HTML> Fri, 08 Jun 2018 16:07:44 GMT https://community.qlik.com/t5/App-Development/Unable-to-multiply-variables-get-totals-in-pivot-charts/m-p/75429#M5007 Anonymous 2018-06-08T16:07:44Z Re: Unable to multiply variables/get totals in pivot charts https://community.qlik.com/t5/App-Development/Unable-to-multiply-variables-get-totals-in-pivot-charts/m-p/75430#M5008 <HTML><HEAD></HEAD><BODY><P>Which tab am I looking at?</P></BODY></HTML> Fri, 08 Jun 2018 16:46:54 GMT https://community.qlik.com/t5/App-Development/Unable-to-multiply-variables-get-totals-in-pivot-charts/m-p/75430#M5008 sunny_talwar 2018-06-08T16:46:54Z Re: Unable to multiply variables/get totals in pivot charts https://community.qlik.com/t5/App-Development/Unable-to-multiply-variables-get-totals-in-pivot-charts/m-p/75431#M5009 <HTML><HEAD></HEAD><BODY><P>Sorry. Tab "What if"</P></BODY></HTML> Fri, 08 Jun 2018 16:48:08 GMT https://community.qlik.com/t5/App-Development/Unable-to-multiply-variables-get-totals-in-pivot-charts/m-p/75431#M5009 Anonymous 2018-06-08T16:48:08Z