Discussion Board for collaboration related to Creating Analytics for QlikView.
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?
What is the format of your year field, is it 2012, 2013, 2014....? Would you be able to share a sample?
These two expression working fine for me.
Remove only() and use your function.
Yes, it is 2012, 2013... Unfortunately I can't make sample file right now.
Only other thing I can think of is, if your Year and [Sales Amount] are not connected to each other. Can you may be share a snapshot of your datamodel?
Sorry, I can't do that either now, but Sales Amount and Year are both in a same table.
-Can you please check the Date field is in which format .(DD/MM/YYYY)
-Upload your Calendar Script.
This may help to solve it.
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:
Field name is case sensitive. Is it year or Year? And check :Preparing examples for Upload - Reduction and Data Scrambling
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..