Discussion Board for collaboration on QlikView Scripting.
I have declared a variable like this
Which is equal to 201401.
and loaded the data like
Load * from table
But I am getting all the data and the check condition is failing.
Please let me know the error in the code.....
Go to Solution.
LET vAccountingPeriod= floor(ADDMONTHS(YEARSTART(Now()),-12));
where floor(Date#([Acct-PrdOO],'YYYYMM')) > $(vAccountingPeriod);
As you have already set the format in the variable, you should be able to just use
hope that helps
Its working!!! Could I know the reason please
When using dates in comparisons it's often wise to use only the numeric value and not mess around with the different format string representations of the dates.