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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Condition problem

Hi,

I need tu build condition sth like MonthYear is lower than Apr-2010. The formula:

Num(MonthYear)<num( 'Apr-' & LastSalesYear)

LastSalesYear is variable.



does not work. Can somebody help me?

1 Reply
Anonymous
Not applicable
Author

Can't tell without knowing the format of your MonthYear field. And, the part on the right is not numeric in any case.
I would do it in a different way:
date < makedate(year(today())-1,4)
that is, date < April 1, 2009, if today is year 2010.