topic Re: expression total and excel total not tie up in QlikView https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221795#M859490 <HTML><HEAD></HEAD><BODY><P>not sure in my data model...total alone is not correct when i use expression total...cant share the data</P><P></P><P>any one knows what could be the reason?</P></BODY></HTML> Tue, 24 Jan 2017 09:06:05 GMT gauthamchilled 2017-01-24T09:06:05Z expression total and excel total not tie up https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221789#M859484 <HTML><HEAD></HEAD><BODY><P>In the attached qlikview, the variance and variance % total is not tie up with excel calculations. can any one help?<IMG __jive_id="150608" alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/150608_Capture.JPG" style="height: 267px; width: 620px;" /></P><P></P><P>Regards,</P><P>Gautham</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221789#M859484 gauthamchilled 2020-11-25T16:16:04Z Re: expression total and excel total not tie up https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221790#M859485 <HTML><HEAD></HEAD><BODY><P>Looks like your QVW is empty.</P></BODY></HTML> Tue, 24 Jan 2017 07:11:43 GMT https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221790#M859485 MK_QSL 2017-01-24T07:11:43Z Re: expression total and excel total not tie up https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221791#M859486 <HTML><HEAD></HEAD><BODY><P>sorry...attached the updated one now<IMG src="https://community.qlik.com/legacyfs/online/emoticons/silly.png" /></P></BODY></HTML> Tue, 24 Jan 2017 07:23:31 GMT https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221791#M859486 gauthamchilled 2017-01-24T07:23:31Z Re: expression total and excel total not tie up https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221792#M859487 <HTML><HEAD></HEAD><BODY><P>Your expressions do not tie. Try expression: <STRONG>=(column(3)/column(1))*100</STRONG>&nbsp;&nbsp; for Variance%</P></BODY></HTML> Tue, 24 Jan 2017 07:35:14 GMT https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221792#M859487 tresB 2017-01-24T07:35:14Z Re: expression total and excel total not tie up https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221793#M859488 <HTML><HEAD></HEAD><BODY><P>Remember BODMASS <IMG src="https://community.qlik.com/legacyfs/online/emoticons/silly.png" /></P><P></P><P><STRONG>(</STRONG>column(2)-column(1)<STRONG>)</STRONG><SPAN style="font-size: 10pt;">/ </SPAN>column(1)*100</P><P></P><P>earlier it was evaluating</P><P>1)Column 1 / Column 1 first then</P><P>2)&nbsp; * 100 then</P><P>3)column 2 - result !</P></BODY></HTML> Tue, 24 Jan 2017 08:29:57 GMT https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221793#M859488 vinieme12 2017-01-24T08:29:57Z Re: expression total and excel total not tie up https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221794#M859489 <HTML><HEAD></HEAD><BODY><P>Hi Gautham,</P><P>You need to isolate the subtract first, so add bracket as shown below in your expression for variance %</P><P>((column(2)-column(1))/column(1))*100</P></BODY></HTML> Tue, 24 Jan 2017 08:57:53 GMT https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221794#M859489 rong 2017-01-24T08:57:53Z Re: expression total and excel total not tie up https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221795#M859490 <HTML><HEAD></HEAD><BODY><P>not sure in my data model...total alone is not correct when i use expression total...cant share the data</P><P></P><P>any one knows what could be the reason?</P></BODY></HTML> Tue, 24 Jan 2017 09:06:05 GMT https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221795#M859490 gauthamchilled 2017-01-24T09:06:05Z Re: expression total and excel total not tie up https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221796#M859491 <HTML><HEAD></HEAD><BODY><P>Use this expression for last Column...</P><P></P><P>((column(2)-column(1))/column(1))*100</P><P>or</P><P>Num((sum(Proforma)/sum(Existing))-1,'#0.00%')</P></BODY></HTML> Tue, 24 Jan 2017 09:06:57 GMT https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221796#M859491 MK_QSL 2017-01-24T09:06:57Z Re: expression total and excel total not tie up https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221797#M859492 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/150632_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Tue, 24 Jan 2017 09:08:31 GMT https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221797#M859492 gauthamchilled 2017-01-24T09:08:31Z Re: expression total and excel total not tie up https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221798#M859493 <HTML><HEAD></HEAD><BODY><P>check attached file..</P></BODY></HTML> Tue, 24 Jan 2017 09:14:11 GMT https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221798#M859493 MK_QSL 2017-01-24T09:14:11Z Re: expression total and excel total not tie up https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221799#M859494 <HTML><HEAD></HEAD><BODY><P>No, i think you are not getting it...please find the attached i am getting total value as 189. but expected is 42% only</P><P></P><P>Regards,</P><P>Gautham</P></BODY></HTML> Tue, 24 Jan 2017 09:22:43 GMT https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221799#M859494 gauthamchilled 2017-01-24T09:22:43Z Re: expression total and excel total not tie up https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221800#M859495 <HTML><HEAD></HEAD><BODY><P>use</P><P></P><P>(sum(Proforma)-sum(Existing))/sum(Existing)*100</P><P></P><P>or add Square brackets when referring to expression labels</P><P></P><P>([proforma]-[existing])/[existing]*100</P></BODY></HTML> Tue, 24 Jan 2017 09:34:03 GMT https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221800#M859495 vinieme12 2017-01-24T09:34:03Z Re: expression total and excel total not tie up https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221801#M859496 <HTML><HEAD></HEAD><BODY><P>Gautham,</P><P>Change the total mode on your variance expression as shown below, this will fix the total percentage for your column.</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/150639_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 24 Jan 2017 09:53:53 GMT https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221801#M859496 rong 2017-01-24T09:53:53Z Re: expression total and excel total not tie up https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221802#M859497 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/194905">gauthamchilled</A> if your query is resolved please close the thread</P><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P></BODY></HTML> Thu, 26 Jan 2017 08:57:27 GMT https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221802#M859497 vinieme12 2017-01-26T08:57:27Z Re: expression total and excel total not tie up https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221803#M859498 <HTML><HEAD></HEAD><BODY><P>Change your Variance % expression to</P><P></P><P><SPAN style="color: #ff8000; font-size: 8pt; text-decoration: underline;"><STRONG>(</STRONG></SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">column</SPAN><SPAN style="font-size: 8pt;">(2)-</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">column</SPAN><SPAN style="font-size: 8pt;">(1))/</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">column</SPAN><SPAN style="font-size: 8pt;">(1)</SPAN><STRONG style=": ; color: #ff8000; font-size: 8pt; text-decoration: underline;">)</STRONG><SPAN style="font-size: 8pt;">*100 </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Some brackets were missing.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/150951_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P></BODY></HTML> Thu, 26 Jan 2017 11:04:24 GMT https://community.qlik.com/t5/QlikView/expression-total-and-excel-total-not-tie-up/m-p/1221803#M859498 Anonymous 2017-01-26T11:04:24Z