set analysis for date ranges

[#1]

Hi,

          I am writing a set analysis for data on policy count between some date range but not getting it working. Attached is the screen shot for the set analysis.

The Date function is getting a red underline.

Thanks

Lax

[#2]

Hi,

I guess this seems to work, but let me validate the data completely. btw why the exp. has changed drastically here. why can't I directly match the years in my set expression instead of writing if condition.

Thanks

Lax

[CELAMBARASAN]

Hi,

     Set analysis compares with the value not directly with the field name.

Celambarasan

[#4]

Hi, so there is now way to use the following exp.

     =count({<POLICYSTATUS={'Withdrawal'},POLICY_EXIT_DATE=ELIGIBILITY_DATE>}POLICYNUMBER)

Further in the exp.

=Sum(Aggr(if(Year(EXTRACTIONDATE)=Year(ELIGIBILITY_DATE),1,0),POLICYNUMBER)).

How can I add one more filter. For eg. I want this data to be stacked based on field COMMENCEMENT_DATE

Regards

Lax

[CELAMBARASAN]

Hi,

     COMMENCEMENT_DATE ?

     Could you describe it little more brief please.

Celambarasan

[#6]

Hi, This is again an attribute of policy. Ok lets take POLICYYEAR instead of COMMENCEMENTDATE. For each of the policy there would be POLICYYEAR. We already have ELIGIBILITY_DATE, EXTRACTIONDATE,POLICYSTATUS. Using this attributes , we are now getting the policy count for respective eligible year and extraction date.

I already have a policy count for the eligible year, in that count I want to bifurgate into commencement year . If the policy count for a year say 2011 is 100 ( got from the expression above) . out of this 100 , 60 are with policyyear 3, 30 are with policyyear 3 and 10 are with policyyear 5. You would have 3 different color in the bar with contribution of

policy count for each of this policy years. Something similar like below image.

Thanks

Lax

[CELAMBARASAN]

Hi,

     Adding PolicyYear as another dimension didn't solve your problem?

Celambarasan