If with an and statement - Alternative

[helen_pip]

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

[rubenmarin]

Hi Helen, you can try with:

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

[sunny_talwar · Accepted solution]

May be this

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

[helen_pip]

Thanks Sunny

This works and you are as helpful as always

Thank you!