Replace Nested If with Mapping Table

[#1]

I have a calculated dimension in a pivot table which is using nested ifs. There are more than 200 cases, and it seems that there is a limit around 100 fo rthe number of nested if statements...

So that I would like to now about alternatives WITHOUT SCRIPTING. Is it possible for instance to have a mapping table defined in a QV object, which can be refered to in the pivot table ? Or to define variables that are then used in the calculated dimension ?

If new variables were to be added, is it possible in the Full Browser version, and how to proceed ?

Thanks in advance

[alexandros17]

I think that variables could help you somehow, have you tried wildmatch?

[mahesh_agrawal]

Can u share the application?

[#4]

I cannot share the application.

Could you give one example use with wildmatch?

Thanks in advance

[maleksafa]

can't you do that from the script or in your reloader script, you should limit and even note use calculated dimensions.

[#6]

I have no access to the script on this occasion... I work on a document on a server and i cannot either script or write macros.

[#7]

Is it possible to create variables and work with new variables in the QV Full Browser version ?

[alexandros17]

In your objects? Yes!

[marcus_sommer]

In most cases nested if-loops could be replaced by pick(match()). Have a look on this and similar postings Re: Fieldname<> multiple values question and in F1.

- Marcus

[jaimeaguilar]

Also using pick(match()) is more efficient in terms of calculation time than nested if, especially if you have plenty of cases,

regards