topic Re: How to compare 2 values ? in QlikView https://community.qlik.com/t5/QlikView/How-to-compare-2-values/m-p/417286#M700653 <HTML><HEAD></HEAD><BODY><P>Add another expression:</P><P>sum(Vlr)/Above(sum(Vlr)) and format it as a %</P></BODY></HTML> Mon, 19 Nov 2012 16:49:04 GMT Clever_Anjos 2012-11-19T16:49:04Z How to compare 2 values ? https://community.qlik.com/t5/QlikView/How-to-compare-2-values/m-p/417283#M700646 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I'm new on Qlikview, and I'd like to compare 2 years, month by month.(Janv.2011 vs Janv 2012) </P><P></P><P>Can you explain me how can I do this ? I tried to do this but it didnt' work.</P><P></P><P>For years, I used the fonction year(date_facturation) and for months I used the fonction month(date_facturation).</P><P></P><P>Thank you very much,</P></BODY></HTML> Thu, 08 Nov 2012 16:53:01 GMT https://community.qlik.com/t5/QlikView/How-to-compare-2-values/m-p/417283#M700646 2012-11-08T16:53:01Z Re: How to compare 2 values ? https://community.qlik.com/t5/QlikView/How-to-compare-2-values/m-p/417284#M700649 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>PFA</P><P></P><P>Are you looking like this</P></BODY></HTML> Thu, 08 Nov 2012 17:12:36 GMT https://community.qlik.com/t5/QlikView/How-to-compare-2-values/m-p/417284#M700649 MayilVahanan 2012-11-08T17:12:36Z Re: How to compare 2 values ? https://community.qlik.com/t5/QlikView/How-to-compare-2-values/m-p/417285#M700651 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thank you for your answer,</P><P></P><P>I'm sorry, but it doesn't work, i'd like to divide 2011 with 2012, month by month.</P><P></P><P>Have you got any idea ?</P><P></P><P>Thank you very much.</P></BODY></HTML> Mon, 19 Nov 2012 16:38:11 GMT https://community.qlik.com/t5/QlikView/How-to-compare-2-values/m-p/417285#M700651 2012-11-19T16:38:11Z Re: How to compare 2 values ? https://community.qlik.com/t5/QlikView/How-to-compare-2-values/m-p/417286#M700653 <HTML><HEAD></HEAD><BODY><P>Add another expression:</P><P>sum(Vlr)/Above(sum(Vlr)) and format it as a %</P></BODY></HTML> Mon, 19 Nov 2012 16:49:04 GMT https://community.qlik.com/t5/QlikView/How-to-compare-2-values/m-p/417286#M700653 Clever_Anjos 2012-11-19T16:49:04Z Re: How to compare 2 values ? https://community.qlik.com/t5/QlikView/How-to-compare-2-values/m-p/417287#M700655 <HTML><HEAD></HEAD><BODY><P>Thank you very much, it works.</P></BODY></HTML> Thu, 22 Nov 2012 13:25:07 GMT https://community.qlik.com/t5/QlikView/How-to-compare-2-values/m-p/417287#M700655 2012-11-22T13:25:07Z