topic Diferencia in QlikView https://community.qlik.com/t5/QlikView/Diferencia/m-p/402420#M149757 <HTML><HEAD></HEAD><BODY><P>hi, </P><P></P><P></P><P>i have the following data:<BR /> </P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 261px;"><TBODY><TR><TD class="xl64" height="17" width="125">COST 1</TD><TD class="xl64" style="border-left: medium none;" width="136">COST 2</TD></TR><TR><TD class="xl63" height="17" style="border-top: medium none;">20000</TD><TD class="xl63" style="border-left: medium none; border-top: medium none;">25000</TD></TR></TBODY></TABLE><P></P><P></P><P><SPAN id="result_box" lang="en"><SPAN class="hps">may I be</SPAN> <SPAN class="hps">directly</SPAN> <SPAN class="hps">plotted</SPAN> <SPAN class="hps">to</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">difference</SPAN> <SPAN class="hps">between</SPAN> <SPAN class="hps">the two data</SPAN><SPAN>?</SPAN></SPAN> </P><P></P><P>Thanks</P></BODY></HTML> Mon, 03 Dec 2012 22:27:09 GMT 2012-12-03T22:27:09Z Diferencia https://community.qlik.com/t5/QlikView/Diferencia/m-p/402420#M149757 <HTML><HEAD></HEAD><BODY><P>hi, </P><P></P><P></P><P>i have the following data:<BR /> </P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 261px;"><TBODY><TR><TD class="xl64" height="17" width="125">COST 1</TD><TD class="xl64" style="border-left: medium none;" width="136">COST 2</TD></TR><TR><TD class="xl63" height="17" style="border-top: medium none;">20000</TD><TD class="xl63" style="border-left: medium none; border-top: medium none;">25000</TD></TR></TBODY></TABLE><P></P><P></P><P><SPAN id="result_box" lang="en"><SPAN class="hps">may I be</SPAN> <SPAN class="hps">directly</SPAN> <SPAN class="hps">plotted</SPAN> <SPAN class="hps">to</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">difference</SPAN> <SPAN class="hps">between</SPAN> <SPAN class="hps">the two data</SPAN><SPAN>?</SPAN></SPAN> </P><P></P><P>Thanks</P></BODY></HTML> Mon, 03 Dec 2012 22:27:09 GMT https://community.qlik.com/t5/QlikView/Diferencia/m-p/402420#M149757 2012-12-03T22:27:09Z Re: Diferencia https://community.qlik.com/t5/QlikView/Diferencia/m-p/402421#M149758 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P> Yes, </P><P></P><P>= Cost2 - Cost1</P><P></P><P>or</P><P></P><P>=Sum(Cost2)- Sum(Cost1) if you have any other field related..For ex:</P><P>ID,Cost1,Cost2</P><P>1,345,3456</P><P>1,34,26</P><P>2,45,75</P><P>2,567,987</P><P></P><P>In this, Cost2-Cost1 not suits, so use Sum(COst2)-Sum(Cost1) as expression and ID as dimension</P></BODY></HTML> Mon, 03 Dec 2012 23:17:54 GMT https://community.qlik.com/t5/QlikView/Diferencia/m-p/402421#M149758 MayilVahanan 2012-12-03T23:17:54Z