Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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

@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") 😉