topic how to make this set analysis work in QlikView

how to make this set analysis work

Sat, 28 Apr 2012 07:41:00 GMT

Hi,

I am don't get any data for this set analysis

count({<ELIGIBILITY_DATE={" <=('31-03-2011')"}>}POLICYNO) .

1. what will be set analysis for the above one

2. if the hardcoded date is replaced by a variable say vLastDate

3. if the hardcoded date is replaced by another date dimension say TERMINATE_DATE

thanks

Lax

CELAMBARASAN — Sat, 28 Apr 2012 07:52:02 GMT

Hi,

Check with this

count({<ELIGIBILITY_DATE={" <=$(=Date(Date#('31-03-2011','DD-MM-YYYY')))"}>}POLICYNO)

count({<ELIGIBILITY_DATE={" <=$(=Date(Date#(vLastDate,'DD-MM-YYYY')))"}>}POLICYNO)

count({<ELIGIBILITY_DATE={" <=$(=Date(Date#(TERMINATE_DATE,'DD-MM-YYYY')))"}>}POLICYNO)

Celambarasan