Less than or Equal to Set Analysis

[#1]

Hi Everyone,

Please I am trying to calculate an expression for less than or equal to No Longer Here  (NLE_MonthName). I am using Set analysis to set the NLE_Year to VCurrentYear and NLE_Month=Jan. Shouldn't this set the NLE_MonthName = 'Jan 2012'? So why does the following expression fail to bring back any records.

Count ({<NLE_Year={'$(vCurrentYear)'},NLE_Month={'Jan'},NLE_MonthName {"$(<=Date(MonthEnd(Date#(DOH_MonthName, 'MMM YYYY')),'MMM YYYY'))"}>}  EmployeeDirectory.ID)

Thank you in advance,

OnePuttGirl

[thomas_skariah]

Hi OnePuttGirl,

You can get an idea from the below link.

http://community.qlik.com/message/253866#253866

Regards,

Tom

[SunilChauhan]

I thing you are missing = sign after NLE_MonthName

use below code

Count ({<NLE_Year={'$(vCurrentYear)'},NLE_Month={'Jan'},NLE_MonthName=

{"$(<=Date(MonthEnd(Date#(DOH_MonthName, 'MMM YYYY')),'MMM YYYY'))"}>}  EmployeeDirectory.ID)

Hope this helps