topic Re: Expressions in QlikView

Expressions

mohan2391 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have 2 expressions and i made modifications to them. So my question is, are the changes done by me working fine or not ?

I mean the new expressions will be giving the same outputs as old expressions outputs or not.

1. OLD_Expr:

sum(IF(Guidance_Method_for_APT='MBG',If(SUM(TARGET_REVENUE)=0,0,SUM(NET_REVENUE)),

IF(Guidance_Method_for_APT='DBG',sum(NET_REV_GUID_DBG))))

NEW_Expr:

SUM({<TARGET_REVENUE-={0},Guidance_Method_for_APT={'MBG'}>}NET_REVENUE)

sum({<Guidance_Method_for_APT={'DBG'}>}NET_REV_GUID_DBG)

2.OLD_Expr:

SUM(IF(Guidance_Method_for_APT='MBG',If(SUM(TARGET_REVENUE)=0,0,SUM(NET_REVENUE)),IF(Guidance_Method_for_APT='DBG',sum(NET_REV_GUID_DBG))))

SUM(IF(Guidance_Method_for_APT='MBG',SUM(TARGET_REVENUE),IF(Guidance_Method_for_APT='DBG',sum(TARGET_REVENUE_DBG))))

NEW_Expr:

(SUM({<TARGET_REVENUE-={0},Guidance_Method_for_APT={'MBG'}>}NET_REVENUE)

sum({<Guidance_Method_for_APT={'DBG'}>}NET_REV_GUID_DBG))

(sum({<Guidance_Method_for_APT={'MBG'}>}TARGET_REVENUE)

sum({<Guidance_Method_for_APT={'DBG'}>}TARGET_REVENUE_DBG))

Please check and let me know.

Thank you

Re: Expressions

Anonymous — Wed, 07 Dec 2016 06:48:54 GMT

Hi ,

Can you share Sample Files.

Re: Expressions

Anonymous — Wed, 07 Dec 2016 06:50:02 GMT

Hi,

Share some sample data so we can use your expression for verification.

Thanks,

Re: Expressions

Anonymous — Wed, 07 Dec 2016 07:43:45 GMT

Hi,

From first view ...it seems that your results will be different as you are adding up data in set analysis while in if condition you have given on addition in else statement.

Share your sample data for more clarity.

Thanks,

Re: Expressions

mohan2391 — Wed, 07 Dec 2016 08:01:45 GMT

Please go through this thread, here you have given reply.

Re: Expressions

mohan2391 — Wed, 07 Dec 2016 08:01:56 GMT

Expression

Re: Expressions

Anonymous — Wed, 07 Dec 2016 11:42:24 GMT

Hi Mohan,

Here scenario is different beacuse we are comparing with your old and new expressions. means if and ste analysis conditions.

Thanks,

Re: Expressions

Anil_Babu_Samineni — Wed, 07 Dec 2016 12:06:38 GMT

Do you check values for same, If so that would be correct. If not, it won't be correct values please check and let us know so that we can move next steo