Multiple conditions in set analysis

[#1]

Hi Friends !

I'm having a doubt in applying  multiple conditions of set analysis.I'm getting output for one expression and not getting for another one.Can anyone pls help me out.

My expression is which i'm getting output.

=count({CLM_CR_DT={ '>=$(=vCurrentYear)<=$(=vCurrentYear-2) '}>}CLM_NO)

and not getting for

=count({CL_APPR_DT={ '>=$(=vCurrentYear)<=$(=vCurrentYear-2) '}>}CLO_LPO_NO)

i have checked that data is presented in QVD.But im getting as 0.

My output should be like

Year    Count(CLM_NO)    Count(CLO_LPO_NO)

2014           45                               55

2013       34                                   34

2012         23                                 21 

Please any one can help me out from this issue.

Regards

Krish             

Message was edited by: krish krish

[ashfaq_haseeb]

Hi,

Try Below.

=count({CL_APPR_DT={ '>={$(=max(Year))}<={$(=max(Year)-2)} '}>}CLO_LPO_NO)

Regards

ASHFAQ

[sasikanth]

HI

can you check weather the data is there for CLO_LPO for current year,

[#4]

Dear Ashfaq,

Still im getting same output.I'm having small doubt.First of all i need to say this QVD was not created by me.In the first expression i have mentioned the date field name  called CLM_CR_DT is in No.format like 345632.2345 and CL_APPR_DT is in right format like 31/10/2012 00:00:00.This may effects to the expression for getting output?

Regards

Krish

[#5]

Hi Sasi,

Ya its there...

Regards

Krish

[ashfaq_haseeb]

Hi,

Format masking is very important part in Set Analysis.

Can you post your sample app.

Regards

ASHFAQ

[#7]

hi,

you have to use ( around you calculation with the variable

=count({CL_APPR_DT={ '>=$(=vCurrentYear)<=$(=(vCurrentYear-2)) '}>}CLO_LPO_NO)

otherwise set analysis has problems to calculate.

I hope this solves your problem

regards,

MT