Discussion Board for collaboration related to QlikView App Development.
We have PTS value from Jul’17 to till date prior to that we have Sales bonus value( from beginning to 30-06-2017)
Now my requirement is If user select financial year 18-19 and month apr to jun
Then it will display Last year bonus value (Apr-17 to Jun-17)
And if user select 18-19 and month July then it will display last year PTS value (Jul-17)
have you tried using triggers
Or simply create another measure in the script with Last year bonus value upto last month i.e. upto June18 & last year PTS value for July18 (Current month) then use this measure.
I guess this is the table you are talking about
What is the numerical output you are looking to get in the above sample?