topic Re: Multiple conditions in set analysis in QlikView

Multiple conditions in set analysis

Wed, 25 Jun 2014 05:23:59 GMT

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

Re: Multiple conditions in set analysis

ashfaq_haseeb — Wed, 25 Jun 2014 05:30:11 GMT

Hi,

Try Below.

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

Regards

ASHFAQ

Re: Multiple conditions in set analysis

sasikanth — Wed, 25 Jun 2014 05:35:48 GMT

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

Re: Multiple conditions in set analysis

Wed, 25 Jun 2014 05:41:02 GMT

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

Re: Multiple conditions in set analysis

Wed, 25 Jun 2014 05:42:07 GMT

Hi Sasi,

Ya its there...

Regards

Krish

Re: Multiple conditions in set analysis

ashfaq_haseeb — Wed, 25 Jun 2014 05:44:20 GMT

Hi,

Format masking is very important part in Set Analysis.

Can you post your sample app.

Regards

ASHFAQ

Re: Multiple conditions in set analysis

Wed, 25 Jun 2014 05:50:32 GMT

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,