Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think that variables could help you somehow, have you tried wildmatch?
Can u share the application?
I cannot share the application.
Could you give one example use with wildmatch?
Thanks in advance
can't you do that from the script or in your reloader script, you should limit and even note use calculated dimensions.
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.
Is it possible to create variables and work with new variables in the QV Full Browser version ?
In your objects? Yes!
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
Also using pick(match()) is more efficient in terms of calculation time than nested if, especially if you have plenty of cases,
regards