topic Re: Regarding % calculation in QlikView https://community.qlik.com/t5/QlikView/Regarding-calculation/m-p/855697#M299930 <HTML><HEAD></HEAD><BODY><P>If I have understand correctly you can try Sum(SALARY) /Sum(TOTAL SALARY) </P></BODY></HTML> Mon, 06 Apr 2015 15:22:49 GMT fvelascog72 2015-04-06T15:22:49Z Regarding % calculation https://community.qlik.com/t5/QlikView/Regarding-calculation/m-p/855695#M299928 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I want to calculate %Calculation like below ...</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AFabulous&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BPerformance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CExcellent&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DVeryGood</P><P>Sum of salary&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 212000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 104000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 57000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 68000</P><P> % Calculation&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 104000/212000*100=49.05%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 57000/212000*100= 26.88%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 68000/212000*100= 32.07%</P><P></P><P>Snapshot is also attached here for more clarity of understanding....</P><P></P><P>In 1st snapshot there is no expression added called %Calculation</P><P><A href="https://community.qlik.com/legacyfs/online/82682_LMS3.png"></A></P><P></P><P><IMG alt="%1.png" class="jive-image image-1" src="/legacyfs/online/82902_%1.png" style="width: 620px; height: 52px;" /></P><P>In Second snapshot the %Calculation expression showing wrong percentage. i want %Calculation to be shown in Total Mode only... not with Dimension's ..is it possible ,if yes then suggest me how i can achive the same with above calculation.</P><P></P><P><IMG alt="%2.png" class="jive-image image-1" src="/legacyfs/online/82903_%2.png" style="width: 620px; height: 66px;" /></P><P></P><P>my Qvw is also attached here for your reference.</P><P></P><P><A href="https://community.qlik.com/legacyfs/online/82683_LMS4.png"></A></P><P>Sarfaraz</P></BODY></HTML> Mon, 06 Apr 2015 07:00:19 GMT https://community.qlik.com/t5/QlikView/Regarding-calculation/m-p/855695#M299928 sarfaraz_sheikh 2015-04-06T07:00:19Z Re: Regarding % calculation https://community.qlik.com/t5/QlikView/Regarding-calculation/m-p/855696#M299929 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P>=Sum(SALARY) /Sum(TOTAL {&lt;Remarks={'AFaboulous'}&gt;}SALARY) </P></BODY></HTML> Mon, 06 Apr 2015 15:22:09 GMT https://community.qlik.com/t5/QlikView/Regarding-calculation/m-p/855696#M299929 2015-04-06T15:22:09Z Re: Regarding % calculation https://community.qlik.com/t5/QlikView/Regarding-calculation/m-p/855697#M299930 <HTML><HEAD></HEAD><BODY><P>If I have understand correctly you can try Sum(SALARY) /Sum(TOTAL SALARY) </P></BODY></HTML> Mon, 06 Apr 2015 15:22:49 GMT https://community.qlik.com/t5/QlikView/Regarding-calculation/m-p/855697#M299930 fvelascog72 2015-04-06T15:22:49Z Re: Regarding % calculation https://community.qlik.com/t5/QlikView/Regarding-calculation/m-p/855698#M299931 <HTML><HEAD></HEAD><BODY><P>use this,</P><P>expression: =Sum(SALARY) / Sum({&lt;Remarks={'AFaboulous'}&gt;} Total SALARY)</P></BODY></HTML> Mon, 06 Apr 2015 15:57:35 GMT https://community.qlik.com/t5/QlikView/Regarding-calculation/m-p/855698#M299931 buzzy996 2015-04-06T15:57:35Z Re: Regarding % calculation https://community.qlik.com/t5/QlikView/Regarding-calculation/m-p/855699#M299932 <HTML><HEAD></HEAD><BODY><P>check out the attached qvw for solution</P></BODY></HTML> Mon, 06 Apr 2015 16:21:39 GMT https://community.qlik.com/t5/QlikView/Regarding-calculation/m-p/855699#M299932 Anonymous 2015-04-06T16:21:39Z Re: Regarding % calculation https://community.qlik.com/t5/QlikView/Regarding-calculation/m-p/855700#M299933 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>The expression should be =Sum(SALARY) / Sum({&lt;Remarks={'AFaboulous'}&gt;} Total SALARY)</P><P>And the number format should be set to fixed/percent.</P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Mon, 06 Apr 2015 16:26:52 GMT https://community.qlik.com/t5/QlikView/Regarding-calculation/m-p/855700#M299933 jonathandienst 2015-04-06T16:26:52Z