topic Re: Set expression with condition in QlikView

Set expression with condition

prma7799 — Thu, 26 Jul 2018 10:00:35 GMT

Dear All,

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)

Re: Set expression with condition

thevingo — Thu, 26 Jul 2018 10:25:25 GMT

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.

Re: Set expression with condition

sunny_talwar — Thu, 26 Jul 2018 11:18:14 GMT

I guess this is the table you are talking about

What is the numerical output you are looking to get in the above sample?