topic Re: multiple conditions in Set analysis in QlikView

multiple conditions in Set analysis

krishna20 — Tue, 24 Jun 2014 11:13:06 GMT

Hi Friends,

I'm having a doubt in applying multiple conditions in set analysis.can anyone pls help me out.

my expression is

=count({<CLM_CR_DT={$(=vCurrentYear)}>}+Count({<CLM_CR_DT={$(=vCurrentYear-1)}>}+Count({<CLM_CR_DT={$(=vCurrentYear-2)}>}CLM_NO))).

I have to get the output as

year count(CLM_NO)

2014 23

2013 34

2012 53

Please let me know, is there any mistake in my expression ASAP.I'm not getting any output.

Re: multiple conditions in Set analysis

robert99 — Tue, 24 Jun 2014 11:15:58 GMT

Try

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

+Count({<CLM_CR_DT={$(=vCurrentYear-1)}>}CLM_NO)

+Count({<CLM_CR_DT={$(=vCurrentYear-2)}>}CLM_NO).

Re: multiple conditions in Set analysis

jagan — Tue, 24 Jun 2014 11:16:10 GMT

Hi,

Try like this

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

Hope this helsp u.

Regards,

Jagan.

Re: multiple conditions in Set analysis

jagan — Tue, 24 Jun 2014 11:16:59 GMT

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

Regards,

Jagan.

Re: multiple conditions in Set analysis

krishna20 — Tue, 24 Jun 2014 11:24:47 GMT

Thank u very much Jagan..Its Working.

Re: multiple conditions in Set analysis

jagan — Tue, 24 Jun 2014 11:27:49 GMT

Hi Kalyan,

Please close this thread by giving Correct and Helpful Answers to the posts, so that it would be helpful for others to find the answers.

Regards,

Jagan.

Re: multiple conditions in Set analysis

MayilVahanan — Tue, 24 Jun 2014 11:28:00 GMT

CLM_CR_DT is this date or Year field?

If its date field then instead of this, use Year field.

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

Re: multiple conditions in Set analysis

krishna20 — Tue, 24 Jun 2014 11:32:38 GMT

Dear Ram,

I have to filter the values based on date.

Re: multiple conditions in Set analysis

krishna20 — Tue, 24 Jun 2014 11:38:25 GMT

Hi Jagan,

I applied the same expression for another one.i.e

=count({<CP_CR_DT={'>=$(=vCurrentYear)<=$(=vCurrentYear-2)'}>}CP_Party_ID).

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

=count({<CS_APPR_DT={'>=$(=vCurrentYear)<=$(=vCurrentYear-2)'}>}CS_BI_ID)

but im getting 0 for all values except the before expression.

pls help me out.

Re: multiple conditions in Set analysis

MayilVahanan — Tue, 24 Jun 2014 11:45:13 GMT

Try like this

=Count({<CLM_CR_DT={">=$(=Date(YearStart(Max(CLM_CR_DT), -2)))<=$(=Date(Max(CLM_CR_DT)))"}>}CLM_NO)

Re: multiple conditions in Set analysis

krishna20 — Tue, 24 Jun 2014 11:56:28 GMT

Hi Ram!

The same result i'm getting.is there will be any other issues in this?

Regards

Kalyan

Re: multiple conditions in Set analysis

MayilVahanan — Tue, 24 Jun 2014 12:26:56 GMT

Can you provide a sample file?

Re: multiple conditions in Set analysis

krishna20 — Tue, 24 Jun 2014 12:33:22 GMT

Hi Ram!

I'm unable to find advanced editor to upload this file.can u please provide ur mail ID.

Regards

Kalyan