Discussion Board for collaboration related to QlikView App Development.
I have the following in my set analysis expression and it works fine. However I am struggling with the syntax of this part of the expression when I want to change it to MonthYear being less than or equal to the right side of the equation. I don't know where to put the <=
If you have a date field then you can do like this
Replace DateDimensionName with your date field and confirm you Date field values and Today() value are in the same format if not convert the Date format in above expression.
You can arrive a date field in script like this
MakeDate(Left(MonthYear, 4), Right(MonthYear, 2)) AS DateDimensionName
Hope this helps you.
well you have to make text to Num as Jagan had already suggested how to do that.
if you need to put '<=' it should be numbers as machine can give you greater or lesser in numbers not in test.
OR You can do convert your MonthYear Field from text to date
expression given by Jagan Mohan in your set analysis.