topic Re: Expression in QlikView

Expression

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

Hi,

Can you change the following expression so that performance should be good and result should be same.

SUM(IF(Guidance_Method_for_APT='MBG',[Net Revenue for Guidance],IF(Guidance_Method_for_APT='DBG',[DBG Net Revenue for Guidance])))

SUM(IF(Guidance_Method_for_APT='MBG',[Revenue at Typical],IF(Guidance_Method_for_APT='DBG',[DBG Revenue at Typical]))

)

Thank You

its_anandrjs — Wed, 30 Nov 2016 06:52:54 GMT

Try this with complete statement with set analysis.

=(Sum({<Guidance_Method_for_APT={'MBG'}>} [Net Revenue for Guidance]) + Sum({<Guidance_Method_for_APT={'DBG'}>} [DBG Net Revenue for Guidance]))

(sum({<Guidance_Method_for_APT={'MBG'}>} [Revenue at Typical] ) + Sum({<Guidance_Method_for_APT={'DBG'}>} [DBG Revenue at Typical]))

Regards

Anand

Anonymous — Wed, 30 Nov 2016 06:54:38 GMT

You can apply set analysis in this as following:

(Sum({<Guidance_Method_for_APT={'MBG'}>}[Net Revenue for Guidance])+

sum({<Guidance_Method_for_APT={'DBG'}>}[DBG Net Revenue for Guidance]))

(sum({<Guidance_Method_for_APT={'MBG'}>}[Revenue at Typical]+

sum({<Guidance_Method_for_APT={'DBG'}>}[DBG Revenue at Typical]))

Thanks,