topic Re: Less than or Equal to Set Analysis in QlikView

Less than or Equal to Set Analysis

Wed, 17 Oct 2012 19:45:32 GMT

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

Re: Less than or Equal to Set Analysis

thomas_skariah — Thu, 18 Oct 2012 01:47:24 GMT

Hi OnePuttGirl,

You can get an idea from the below link.

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

Regards,

Tom

Re: Less than or Equal to Set Analysis

SunilChauhan — Thu, 18 Oct 2012 07:22:51 GMT

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