Replace Multiple If Statements

[#1]

Hi all,

Quick one. I have multiple nested ifs statement, say about 20 statements. I do realise that I shouldn't have that many if statements, so really looking for a better way.

QlikView seems to recognise the first 10 or so statements and then doesn't recognise the other statements.

Is there a way to rewrite this or an alternative to get this to work?

Any help will be appreciated.

[#2]

Does the attached example help?

This allows you to select step 1, then 2 and objects enable ans disable accordingly.

Richard

[#3]

Thanks Richard, that's very useful.

I was really hoping to avoid a calculation for every object/sheet as it means maintaining it will be tricky

[Anonymous]

Can we use this in script as well.

[#5]

Thanks to everyone for their responses.

I had some blank spaces in my if statements/pick-match expressions when I shouldn't have had them i.e. Page 12 instead of Page12

I found this out and removed them. Everything is working as expected now