topic Re: Difference between the same value at different date in QlikView https://community.qlik.com/t5/QlikView/Difference-between-the-same-value-at-different-date/m-p/264128#M99314 <HTML><HEAD></HEAD><BODY><P>Hi Pierre,</P><P></P><P>if you want to show the difference between current and previous month you can use "above" function</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code">sum(Value) - above(sum(Value))<BR /></PRE><P></P><P>The function will calculate diff from previous dimension value for each value.</P><P></P><P>Hope this helpes!</P><P>Stefan</P></BODY></HTML> Sat, 04 Jun 2011 10:21:57 GMT 2011-06-04T10:21:57Z Difference between the same value at different date https://community.qlik.com/t5/QlikView/Difference-between-the-same-value-at-different-date/m-p/264127#M99313 <HTML><HEAD></HEAD><BODY><P>Hy experts,</P><P></P><P>I'm new on qlikview.</P><P></P><P>I have a barshart which display the number of sales by date : </P><P>Exemple :</P><P>May : 250</P><P>June : 200</P><P>Jully : 300</P><P></P><P>My question is how to creat a calculated expression to display the difference between two months ?</P><P></P><P>x (June/May) = - 50</P><P>X (Jully/June) = 100</P><P></P><P>Could you help me please ?</P><P></P><P>Regards,</P><P></P><P>Pierre.</P></BODY></HTML> Sat, 04 Jun 2011 09:30:09 GMT https://community.qlik.com/t5/QlikView/Difference-between-the-same-value-at-different-date/m-p/264127#M99313 2011-06-04T09:30:09Z Re: Difference between the same value at different date https://community.qlik.com/t5/QlikView/Difference-between-the-same-value-at-different-date/m-p/264128#M99314 <HTML><HEAD></HEAD><BODY><P>Hi Pierre,</P><P></P><P>if you want to show the difference between current and previous month you can use "above" function</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code">sum(Value) - above(sum(Value))<BR /></PRE><P></P><P>The function will calculate diff from previous dimension value for each value.</P><P></P><P>Hope this helpes!</P><P>Stefan</P></BODY></HTML> Sat, 04 Jun 2011 10:21:57 GMT https://community.qlik.com/t5/QlikView/Difference-between-the-same-value-at-different-date/m-p/264128#M99314 2011-06-04T10:21:57Z Difference between the same value at different date https://community.qlik.com/t5/QlikView/Difference-between-the-same-value-at-different-date/m-p/264129#M99315 <HTML><HEAD></HEAD><BODY><P>Thanks Stefan, it works</P><P></P><P>Regards.</P></BODY></HTML> Sat, 04 Jun 2011 12:01:07 GMT https://community.qlik.com/t5/QlikView/Difference-between-the-same-value-at-different-date/m-p/264129#M99315 2011-06-04T12:01:07Z