Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

Set expression with condition

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)

2 Replies
thevingo
Creator
Creator

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.

sunny_talwar

I guess this is the table you are talking about

Capture.PNG

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