topic Re: Replace Nested If with Mapping Table in QlikView

Replace Nested If with Mapping Table

Mon, 07 Jul 2014 09:43:14 GMT

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

Re: Replace Nested If with Mapping Table

alexandros17 — Mon, 07 Jul 2014 09:45:37 GMT

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

Re: Replace Nested If with Mapping Table

mahesh_agrawal — Mon, 07 Jul 2014 09:47:54 GMT

Can u share the application?

Re: Replace Nested If with Mapping Table

Mon, 07 Jul 2014 09:49:01 GMT

I cannot share the application.

Could you give one example use with wildmatch?

Thanks in advance

Re: Replace Nested If with Mapping Table

maleksafa — Mon, 07 Jul 2014 09:49:17 GMT

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

Re: Replace Nested If with Mapping Table

Mon, 07 Jul 2014 09:51:10 GMT

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.

Re: Replace Nested If with Mapping Table

Mon, 07 Jul 2014 11:07:23 GMT

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

Re: Replace Nested If with Mapping Table

alexandros17 — Mon, 07 Jul 2014 11:45:26 GMT

In your objects? Yes!

Re: Replace Nested If with Mapping Table

marcus_sommer — Mon, 07 Jul 2014 15:15:07 GMT

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

Re: Replace Nested If with Mapping Table

jaimeaguilar — Mon, 07 Jul 2014 15:52:06 GMT

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

regards