topic Re: Definitions Sales Difference and Sales Variance in QlikView https://community.qlik.com/t5/QlikView/Definitions-Sales-Difference-and-Sales-Variance/m-p/540233#M482675 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">This formula</SPAN> <SPAN class="hps">is not correct</SPAN><SPAN>,</SPAN> <SPAN class="hps">he</SPAN> <SPAN class="hps">doesn't </SPAN><SPAN class="hps">calculate the</SPAN> <SPAN class="hps">formula</SPAN> <SPAN class="hps">this way:</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"></SPAN></SPAN></P><P>,(<SPAN lang="EN-US" style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">[Sales<BR />$(vMaxYear)]</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 9pt;"> - </SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">[Sales<BR />$(vPriorYear)]</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 9pt;">) / fabs(</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">[Sales<BR />$(vPriorYear)]</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 9pt;">)</SPAN></P><P><SPAN lang="en"><SPAN class="hps"></SPAN></SPAN></P></BODY></HTML> Thu, 01 Aug 2013 07:17:28 GMT 2013-08-01T07:17:28Z Definitions Sales Difference and Sales Variance https://community.qlik.com/t5/QlikView/Definitions-Sales-Difference-and-Sales-Variance/m-p/540231#M482673 <HTML><HEAD></HEAD><BODY><P style="background: whitesmoke;"><SPAN style="font-size: 10pt;"><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">Can someone help</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">me with</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">these definitions</SPAN><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">? </SPAN><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">In the table,</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">he gives a</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">Sales</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">Difference</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">of 0</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">and</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">a Sales</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">Variance</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">from</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">100%</SPAN><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">. </SPAN></SPAN></P><P style="background: whitesmoke;"><SPAN style="font-size: 10pt;"><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;"></SPAN><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">What</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">do</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">I do wrong</SPAN> <SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">in the definitions</SPAN><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; color: #222222;">?</SPAN></SPAN></P><P><STRONG><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 9pt;"> </SPAN></STRONG></P><P><STRONG style="color: black; font-size: 9pt; font-family: 'Courier New';">Sales Difference:</STRONG></P><P><STRONG style=": ; color: #ff8000; font-size: 9pt; font-family: 'Courier New'; text-decoration: underline;">(</STRONG><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">[Sales<BR />$(vMaxYear)]</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"> - </SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">[Sales<BR />$(vPriorYear)]</SPAN><STRONG style=": ; color: #ff8000; font-size: 9pt; font-family: 'Courier New'; text-decoration: underline;">) </STRONG></P><P><SPAN style="font-family: 'Courier New'; color: blue; font-size: 9pt;"> </SPAN></P><P><STRONG><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 9pt;">Sales Variance:</SPAN></STRONG></P><P style="background: whitesmoke;"><SPAN lang="EN-US" style="font-family: 'Courier New'; color: blue; font-size: 9pt;">If</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 9pt;">(</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">[Sales<BR />$(vPriorYear)]</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 9pt;"> = 0,1,(</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">[Sales<BR />$(vMaxYear)]</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 9pt;"> - </SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">[Sales<BR />$(vPriorYear)]</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 9pt;">) / fabs(</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">[Sales<BR />$(vPriorYear)]</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 9pt;">))<BR /><SPAN lang="EN-US" style="font-family: 'Courier New'; color: green; font-size: 9pt;">//If statement needed for situation vPriorYear = 0<BR />//fabs statement needed for situation vPriorYear = negative</SPAN></SPAN></P><P style="background: whitesmoke;"><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 9pt;"><SPAN lang="EN-US" style="font-family: 'Courier New'; color: green; font-size: 9pt;"></SPAN></SPAN></P><P style="background: whitesmoke;"><SPAN lang="EN-US" style="font-family: 'Courier New'; color: #000000; font-size: 9pt;"><SPAN lang="EN-US" style="font-family: 'Courier New'; font-size: 9pt;"><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">Thanks in advance!</SPAN></SPAN> </SPAN></SPAN></P><P style="background: whitesmoke;"><SPAN lang="EN-US" style="font-family: 'Courier New'; color: #000000; font-size: 9pt;"><SPAN lang="EN-US" style="font-family: 'Courier New'; font-size: 9pt;"></SPAN></SPAN></P><P style="background: whitesmoke;"><SPAN lang="EN-US" style="font-family: 'Courier New'; color: #000000; font-size: 9pt;"><SPAN lang="EN-US" style="font-family: 'Courier New'; font-size: 9pt;">Mirjam</SPAN></SPAN></P></BODY></HTML> Tue, 30 Jul 2013 14:49:39 GMT https://community.qlik.com/t5/QlikView/Definitions-Sales-Difference-and-Sales-Variance/m-p/540231#M482673 2013-07-30T14:49:39Z Re: Definitions Sales Difference and Sales Variance https://community.qlik.com/t5/QlikView/Definitions-Sales-Difference-and-Sales-Variance/m-p/540232#M482674 <HTML><HEAD></HEAD><BODY><P>You simply set the variance to 1 if the Sales of the prior year is 0:</P><P></P><P><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: blue;">If</SPAN><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">[Sales<BR />$(vPriorYear)]</SPAN><SPAN lang="EN-US" style="font-size: 9pt; font-family: 'Courier New'; color: black;"> = 0,1</SPAN></P><P></P><P>1 is 100%. You don't check if Sales of max year has a value of zero or not.</P></BODY></HTML> Tue, 30 Jul 2013 18:20:18 GMT https://community.qlik.com/t5/QlikView/Definitions-Sales-Difference-and-Sales-Variance/m-p/540232#M482674 Gysbert_Wassenaar 2013-07-30T18:20:18Z Re: Definitions Sales Difference and Sales Variance https://community.qlik.com/t5/QlikView/Definitions-Sales-Difference-and-Sales-Variance/m-p/540233#M482675 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">This formula</SPAN> <SPAN class="hps">is not correct</SPAN><SPAN>,</SPAN> <SPAN class="hps">he</SPAN> <SPAN class="hps">doesn't </SPAN><SPAN class="hps">calculate the</SPAN> <SPAN class="hps">formula</SPAN> <SPAN class="hps">this way:</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"></SPAN></SPAN></P><P>,(<SPAN lang="EN-US" style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">[Sales<BR />$(vMaxYear)]</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 9pt;"> - </SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">[Sales<BR />$(vPriorYear)]</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 9pt;">) / fabs(</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">[Sales<BR />$(vPriorYear)]</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 9pt;">)</SPAN></P><P><SPAN lang="en"><SPAN class="hps"></SPAN></SPAN></P></BODY></HTML> Thu, 01 Aug 2013 07:17:28 GMT https://community.qlik.com/t5/QlikView/Definitions-Sales-Difference-and-Sales-Variance/m-p/540233#M482675 2013-08-01T07:17:28Z Re: Definitions Sales Difference and Sales Variance https://community.qlik.com/t5/QlikView/Definitions-Sales-Difference-and-Sales-Variance/m-p/540234#M482676 <HTML><HEAD></HEAD><BODY><P>Right formula:</P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P><STRONG>Sales Variance:</STRONG> </P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P>If <SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Sales<BR />Difference]</SPAN><SPAN style="font-size: 8pt;"> = 0,0,(If(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Sales<BR />$(vPriorYear)]</SPAN><SPAN style="font-size: 8pt;"> = 0,1,(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Sales<BR />$(vMaxYear)]</SPAN><SPAN style="font-size: 8pt;"> - </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Sales<BR />$(vPriorYear)]</SPAN><SPAN style="font-size: 8pt;">) / fabs(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Sales<BR />$(vPriorYear)]</SPAN><SPAN style="font-size: 8pt;">))))<BR /><BR /></SPAN></P><P><SPAN style="color: #008000; font-size: 8pt;">//If statement nodig voor situatie Sales Difference = 0<BR />//If statement nodig voor situatie Sales vPriorYear = 0<BR />//fabs statement nodig voor situatie Sales vPriorYear = negatief </SPAN></P></BODY></HTML> Thu, 22 Aug 2013 08:16:35 GMT https://community.qlik.com/t5/QlikView/Definitions-Sales-Difference-and-Sales-Variance/m-p/540234#M482676 2013-08-22T08:16:35Z