Discussion Board for collaboration related to QlikView App Development.
There something wrong in expressions I made:
This year sales amount:
Last year sales amount
Sales amount is the same for both of them and it shouldn't be. And year is not max(year). Actually, this just gives a sum of all years or sum of selected year(s).
There was ei trigger on sheet (on opening) where max(year) was automatically selected, but I removed that.
What's wrong in the expressions?
I don't see anything wrong with your syntax, the only thing you can try (although I don't think it will make any difference) is to add single quotes within your set analysis:
Just cross check your values by using the expression like
what is the result for 2015.
Then check for 2014.
you may find out where the mistake will goes..