Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
ZoeM
Specialist
Specialist

Setting conditional expression using Today()

Hi Community.

I have a chart with 6 expressions and I would like to set one expression to only calculate on a condition that the selected Year in the List box equals current year. If the selected year is either greater than or less current year, then it wont calculate.

My conditional expression:

GetCurrentSelections(Year)= Date(Today(),'YYYY') 

But I am not getting any results.

any help with getting the right syntax for the expression will be truly appreciated.

10 Replies
ZoeM
Specialist
Specialist
Author

Smiley Very Happy

Thanks so much, works like a charm now!