Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
simoevry
Contributor
Contributor

Solution for this expression Mesure Plzz

Hi Every One

This my expression Mesure  and I want to show 2,41 in 2015 If any one can help me for this problem.

(sum({1<Marque={'AD'},Year='2015'>}Montant_HT)-sum({1<Marque={'AD'},Year='2014'>}Montant_HT)/sum({1<Marque={'AD'},Year='2014'>}Montant_HT)

Cap1.JPG

3 Replies
vishsaggi
Champion III
Champion III

Can you share some sample data to look into?

simoevry
Contributor
Contributor
Author

In my mesure I calculated EVOLUTION 2015  --->  (SALES2015-SALES 2014)/SALES2014

BUT AFTER ADDED IN TABLE PER YEAR is show me this normally this value should be contain in rows 2015

Cap1.JPG

vishsaggi
Champion III
Champion III

Are you missing an extra bracket here?

= (sum({1<Marque={'AD'},Year='2015'>}Montant_HT) - sum({1<Marque={'AD'},Year='2014'>}Montant_HT)) / sum({1<Marque={'AD'},Year='2014'>}Montant_HT)

IF you can provide some sample data or a sample file will be easy to work on it quickly?