topic Re: Solution for this expression Mesure Plzz in QlikView https://community.qlik.com/t5/QlikView/Solution-for-this-expression-Mesure-Plzz/m-p/1321394#M409435 <HTML><HEAD></HEAD><BODY><P>Can you share some sample data to look into?</P></BODY></HTML> Fri, 14 Apr 2017 15:44:02 GMT vishsaggi 2017-04-14T15:44:02Z Solution for this expression Mesure Plzz https://community.qlik.com/t5/QlikView/Solution-for-this-expression-Mesure-Plzz/m-p/1321393#M409434 <HTML><HEAD></HEAD><BODY><P>Hi Every One</P><P></P><P></P><P>This my expression Mesure&nbsp; and I want to show 2,41 in 2015 If any one can help me for this problem.</P><P></P><P>(sum({1&lt;Marque={'AD'},Year='2015'&gt;}Montant_HT)-sum({1&lt;Marque={'AD'},Year='2014'&gt;}Montant_HT)/sum({1&lt;Marque={'AD'},Year='2014'&gt;}Montant_HT)</P><P></P><P></P><P><IMG __jive_id="160110" alt="Cap1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/160110_Cap1.JPG" style="height: auto;" /></P></BODY></HTML> Fri, 14 Apr 2017 15:31:50 GMT https://community.qlik.com/t5/QlikView/Solution-for-this-expression-Mesure-Plzz/m-p/1321393#M409434 simoevry 2017-04-14T15:31:50Z Re: Solution for this expression Mesure Plzz https://community.qlik.com/t5/QlikView/Solution-for-this-expression-Mesure-Plzz/m-p/1321394#M409435 <HTML><HEAD></HEAD><BODY><P>Can you share some sample data to look into?</P></BODY></HTML> Fri, 14 Apr 2017 15:44:02 GMT https://community.qlik.com/t5/QlikView/Solution-for-this-expression-Mesure-Plzz/m-p/1321394#M409435 vishsaggi 2017-04-14T15:44:02Z Re: Solution for this expression Mesure Plzz https://community.qlik.com/t5/QlikView/Solution-for-this-expression-Mesure-Plzz/m-p/1321395#M409436 <HTML><HEAD></HEAD><BODY><P>In my mesure I calculated EVOLUTION 2015&nbsp; ---&gt;&nbsp; (SALES2015-SALES 2014)/SALES2014</P><P></P><P>BUT AFTER ADDED IN TABLE PER YEAR is show me this normally this value should be contain in rows 2015</P><P></P><P><IMG alt="Cap1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/160111_Cap1.JPG" style="height: auto;" /></P></BODY></HTML> Fri, 14 Apr 2017 16:01:25 GMT https://community.qlik.com/t5/QlikView/Solution-for-this-expression-Mesure-Plzz/m-p/1321395#M409436 simoevry 2017-04-14T16:01:25Z Re: Solution for this expression Mesure Plzz https://community.qlik.com/t5/QlikView/Solution-for-this-expression-Mesure-Plzz/m-p/1321396#M409437 <HTML><HEAD></HEAD><BODY><P>Are you missing an extra bracket here?</P><P></P><P>= (sum({1&lt;Marque={'AD'},Year='2015'&gt;}Montant_HT) - sum({1&lt;Marque={'AD'},Year='2014'&gt;}Montant_HT)<STRONG style="color: #ff0000;">)</STRONG> / sum({1&lt;Marque={'AD'},Year='2014'&gt;}Montant_HT)</P><P></P><P></P><P>IF you can provide some sample data or a sample file will be easy to work on it quickly?</P></BODY></HTML> Fri, 14 Apr 2017 16:29:13 GMT https://community.qlik.com/t5/QlikView/Solution-for-this-expression-Mesure-Plzz/m-p/1321396#M409437 vishsaggi 2017-04-14T16:29:13Z