topic Re: Set analysis with if else in QlikView

Set analysis with if else

krishna20 — Wed, 02 Jul 2014 08:41:43 GMT

Hi,

Can anyone tell me tat how can we write conditional and else statements in a single expression using set analysis.

Regards

krishna

Re: Set analysis with if else

jagan — Wed, 02 Jul 2014 08:45:51 GMT

Hi,

Can you come up with an example and sample output?

Regards,

Jagan.

Re: Set analysis with if else

krishna20 — Wed, 02 Jul 2014 08:48:08 GMT

Hi here is my expression.i'm getting output for only if condtion.Its not moving to another if.

=if(CE_CLOSE_YN='1' and CE_CLOSE_DT<Today(),0,if(CE_CLOSE_YN='1' and CE_CLOSE_DT>Today(),(sum({$<Year={"vCurrentYear-2>vCurrentYear-1<vCurrentYear"}>}CE_AMT_LC_1))))

Regards

Krishna

Re: Set analysis with if else

SunilChauhan — Wed, 02 Jul 2014 08:56:44 GMT

if(CE_CLOSE_YN='1' and CE_CLOSE_DT<Today(),0,if(CE_CLOSE_YN='1' andCE_CLOSE_DT>Today(),(sum({$<Year={"vCurrentYear-2>vCurrentYear-1<vCurrentYear"}>}CE_AMT_LC_1)), elsepartexpression

)

and chcek breakets

Re: Set analysis with if else

krishna20 — Wed, 02 Jul 2014 09:01:47 GMT

Hi Sunil,

thank you for your reply..

In the above expression the second part is my expression its not working.The condition stops with first If condition itself.The else condition is the below one.

if(CE_CLOSE_YN='1'andCE_CLOSE_DT>Today(),(sum({$<Year={"vCurrentYear-2>vCurrentYear-1<vCurrentYear"}>}CE_AMT_LC_1))

Regards

Krishna

Re: Set analysis with if else

VishalWaghole — Wed, 02 Jul 2014 09:03:37 GMT

Hello Kalyan,

Check your CE_CLOSE_DT and Today () format is matching or not.

also check without if statement your set analysis is working or not.

- Regards,

Vishal Waghole

Re: Set analysis with if else

krishna20 — Wed, 02 Jul 2014 09:11:39 GMT

Thank You Vishal

Regards

Krishna

Re: Set analysis with if else

its_anandrjs — Wed, 02 Jul 2014 09:18:49 GMT

Try like

=if(CE_CLOSE_YN='1' and CE_CLOSE_DT<Today(),0,

(sum({$<Year={"vCurrentYear-2>vCurrentYear-1<vCurrentYear"}>}CE_AMT_LC_1)))

=if( (CE_CLOSE_YN ='1' and CE_CLOSE_DT < Today()),0,

if( (CE_CLOSE_YN ='1' and CE_CLOSE_DT > Today()),(sum({$<Year={"vCurrentYear-2>vCurrentYear-1<vCurrentYear"}>}CE_AMT_LC_1))))

Re: Set analysis with if else

SunilChauhan — Wed, 02 Jul 2014 09:26:16 GMT

if(CE_CLOSE_YN='1' and CE_CLOSE_DT<Today(),0,if(CE_CLOSE_YN='1' andCE_CLOSE_DT>Today(),(sum({$<Year={"vCurrentYear-2>vCurrentYear-1<vCurrentYear"}>}CE_AMT_LC_1))), you right here your else part or another if)

as you have already two if one for 0 and other for set expression i.e Sum(....),

HPH

Re: Set analysis with if else

krishna20 — Wed, 02 Jul 2014 09:44:55 GMT

Hi Sunil,

Thank You for your Reply.

My Expression is totally like above.In that i need to check two conditions.The second if condition and sum will be in else part.

Regards

Krishna

Re: Set analysis with if else

SunilChauhan — Wed, 02 Jul 2014 09:50:45 GMT

if(CE_CLOSE_YN='1' and CE_CLOSE_DT<Today(),0,if(CE_CLOSE_YN='1'andCE_CLOSE_DT>Today(),(sum({$<Year={"vCurrentYear-2>vCurrentYear-1<vCurrentYear"}>}CE_AMT_LC_1))),

if(condition1 and condition2, Sum()))

Re: Set analysis with if else

krishna20 — Wed, 02 Jul 2014 09:54:31 GMT

Hi Sunil,

I have to check mainly CE_CLOSE_DT<Today() and CE_CLOSE_DT > Today() with the condition CE_CLOSE_YN='1'

Re: Set analysis with if else

SunilChauhan — Wed, 02 Jul 2014 10:06:44 GMT

if(CE_CLOSE_YN='1'andCE_CLOSE_DT>Today(),(sum({$<Year={"vCurrentYear-2>vCurrentYear-1<vCurrentYear"}>}CE_AMT_LC_1))),

if(CE_CLOSE_YN='1' and CE_CLOSE_DT<Today(),SUM(),0)

might be something like this you want

Re: Set analysis with if else

sasikanth — Wed, 02 Jul 2014 10:13:50 GMT

hi have you checked the both date formats

CE_CLOSE_DT date format

if yes then post your sample file

Re: Re: Set analysis with if else

krishna20 — Wed, 02 Jul 2014 10:24:42 GMT

Hi Sasi.

Pls Find the below attachment .

Regards

Krishna

Re: Set analysis with if else

sasikanth — Wed, 02 Jul 2014 10:28:32 GMT

post only your file .qvw

that zip file not able to open

Re: Re: Set analysis with if else

krishna20 — Wed, 02 Jul 2014 10:34:16 GMT

Hi Sasi

Please find the attachment.

Regards

Krishna

Re: Set analysis with if else

krishna20 — Thu, 03 Jul 2014 06:09:41 GMT

Hi Sasi !

Did u got any way for that?

Regards

Krishna

Re: Set analysis with if else

sasikanth — Thu, 03 Jul 2014 06:11:27 GMT

no yaar i am not able to open that file also , it is giving me error load failed

Re: Set analysis with if else

krishna20 — Thu, 03 Jul 2014 06:15:06 GMT

Hi sasi.

Can you provide your personal mail ID such that i can send the key for Qlikview.Apply it for your personal edition then you can able to open it.

Regards

Krishna