topic Re: Issue with expression: in QlikView https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/1185536#M882166 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a qvw sample to play around with?</P></BODY></HTML> Wed, 28 Sep 2016 17:44:35 GMT sunny_talwar 2016-09-28T17:44:35Z Issue with expression: https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/1185535#M882165 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Table1</P><P>I have two dimensions, Vintage and DLQT_STAT: And have an expression as Sum(Sales).</P><P>Now I have to create a new table.</P><P>Unable to explain the logic, I have created a excel with formula.</P><P>Table2 has same dimensions just need to change the expression. Any idea how I can achieve it?</P><P></P><P>Thanks,</P><P>Pavan</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/1185535#M882165 2020-11-25T16:16:04Z Re: Issue with expression: https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/1185536#M882166 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a qvw sample to play around with?</P></BODY></HTML> Wed, 28 Sep 2016 17:44:35 GMT https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/1185536#M882166 sunny_talwar 2016-09-28T17:44:35Z Re: Issue with expression: https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/1185537#M882167 <HTML><HEAD></HEAD><BODY><P>Try using this:</P><P>Sum(Sales) / Sum(TOTAL Sales)</P><P></P><P>Also do not forget in Presentation tab to change numeric format:</P><P><IMG alt="Screenshot_1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139035_Screenshot_1.jpg" style="height: auto;" /></P><P></P><P>Read more about TOTAL in expression and it's use in here:</P><P><A href="https://community.qlik.com/qlik-blogpost/3285">The Aggregation Scope</A></P><P><A href="https://community.qlik.com/qlik-blogpost/4160">What does the TOTAL qualifier do?</A></P></BODY></HTML> Wed, 28 Sep 2016 17:52:37 GMT https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/1185537#M882167 MindaugasBacius 2016-09-28T17:52:37Z Re: Issue with expression: https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/1185538#M882168 <HTML><HEAD></HEAD><BODY><P>Sure Sunny, adding the sample in a new thread.</P></BODY></HTML> Wed, 28 Sep 2016 18:08:17 GMT https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/1185538#M882168 2016-09-28T18:08:17Z Re: Issue with expression: https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/1185539#M882169 <HTML><HEAD></HEAD><BODY><P>Hi Mindaugas, Its not that simple.</P></BODY></HTML> Wed, 28 Sep 2016 18:08:53 GMT https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/1185539#M882169 2016-09-28T18:08:53Z Re: Issue with expression: https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/1185540#M882170 <HTML><HEAD></HEAD><BODY><P>Hi Pavan,</P><P></P><P>Hope, you are using pivot table. Then try this expression</P><P></P><P><STRONG><EM>Below(sum(Sales))/Before(sum(Sales))</EM></STRONG></P><P></P><P>Format should be, Fixed 2, percentage.</P></BODY></HTML> Wed, 28 Sep 2016 18:52:07 GMT https://community.qlik.com/t5/QlikView/Issue-with-expression/m-p/1185540#M882170 settu_periasamy 2016-09-28T18:52:07Z