2 Replies Latest reply: Oct 13, 2014 5:29 PM by Shana Forrester RSS

    is there an alternative to nested if statements?

      I have an IF statement that populates a variable with another variable depending on the filters selected. There are 133 possible combinations in this nested IF statement and apparently Qlikview limits you to less than that. I am looking for an alternate way to load this. I have seen suggestions for using a mapping load but I am unsure how to apply this in this instance because of the many different combinations of conditions I need. Please see below for a section of the script:

      Untitled.png

      How can I rewrite these options so they will all work? it is my understanding that Qlikview does not support Switch Case statements either...