topic Re: If with an and statement - Alternative in QlikView

If with an and statement - Alternative

helen_pip — Fri, 13 Oct 2017 08:14:59 GMT

Dear Qlikview user

I am in the process of improving performance on an application and have read that If statements are resource hungry

I have changed the bulk of my expressions to be Pick(Match however I am left with a small number of expressions which look like they cannot be improved I.e.

=If(TB_Question = 'Safe' and TB_Show_On_Overview = 1, TB_Metric)

I was wondering if someone could kindly tell me if I should be using a more efficient technique than what is used in the above example. I dont want to over complicate things, if unnecessary

Kind Regards

Helen

Re: If with an and statement - Alternative

rubenmarin — Fri, 13 Oct 2017 08:40:39 GMT

Hi Helen, you can try with:

Only({<TB_Question={'Safe'}, TB_Show_On_Overview={1}>} TB_Metric)

Re: If with an and statement - Alternative

sunny_talwar — Fri, 13 Oct 2017 12:01:00 GMT

May be this

Pick(Match(TB_Question&TB_Show_On_Overview, 'Safe1'), TB_Metric)

Re: If with an and statement - Alternative

helen_pip — Fri, 13 Oct 2017 12:03:21 GMT

Thanks Sunny

This works and you are as helpful as always

Thank you!