Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
saivina2920
Creator
Creator

Passing variable in "If" statement is not working properly

The below expression is working properly.

=if(([EMP_JOIN_DATE]>=Today()-10 AND [EMP_JOIN_DATE]<=Today()),1,0) ==> Working

But, when i use the variable it will not be recognize.  Any syntax issue...?

=if(([EMP_JOIN_DATE]>=$(=vCalDate10) AND [EMP_JOIN_DATE]<=$(=vToday)),1,0) ==> Not working

 

Labels (1)
1 Reply
Taoufiq_Zarra
Master II
Master II

@saivina2920 

=if([EMP_JOIN_DATE]>='$(vCalDate10)' AND [EMP_JOIN_DATE]<='$(vToday)',1,0)

whith variables :

Taoufiq_Zarra_0-1609402827307.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉