topic Re: is there an alternative to nested if statements? in QlikView https://community.qlik.com/t5/QlikView/is-there-an-alternative-to-nested-if-statements/m-p/717039#M671031 <HTML><HEAD></HEAD><BODY><P>You can replace the nested IF statements with mapping tables in some requirements,</P><P></P><P>Please post some sample data &amp; your requirements.</P></BODY></HTML> Mon, 13 Oct 2014 21:22:14 GMT 2014-10-13T21:22:14Z is there an alternative to nested if statements? https://community.qlik.com/t5/QlikView/is-there-an-alternative-to-nested-if-statements/m-p/717038#M671030 <HTML><HEAD></HEAD><BODY><P>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:</P><P><IMG alt="Untitled.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/68819_Untitled.png" style="width: 620px; height: 449px;" /></P><P>How can I rewrite these options so they will all work? it is my understanding that Qlikview does not support Switch Case statements either...</P></BODY></HTML> Mon, 13 Oct 2014 18:32:30 GMT https://community.qlik.com/t5/QlikView/is-there-an-alternative-to-nested-if-statements/m-p/717038#M671030 2014-10-13T18:32:30Z Re: is there an alternative to nested if statements? https://community.qlik.com/t5/QlikView/is-there-an-alternative-to-nested-if-statements/m-p/717039#M671031 <HTML><HEAD></HEAD><BODY><P>You can replace the nested IF statements with mapping tables in some requirements,</P><P></P><P>Please post some sample data &amp; your requirements.</P></BODY></HTML> Mon, 13 Oct 2014 21:22:14 GMT https://community.qlik.com/t5/QlikView/is-there-an-alternative-to-nested-if-statements/m-p/717039#M671031 2014-10-13T21:22:14Z Re: Re: is there an alternative to nested if statements? https://community.qlik.com/t5/QlikView/is-there-an-alternative-to-nested-if-statements/m-p/717040#M671032 <HTML><HEAD></HEAD><BODY><P>Attached is the code I need to replace. I am setting a variable vTarget based on a combination of filters chosen in the dashboard. There are 133 conditions available but only 99 allowed in a nested if so I need an alternative way to do this.</P></BODY></HTML> Mon, 13 Oct 2014 21:29:15 GMT https://community.qlik.com/t5/QlikView/is-there-an-alternative-to-nested-if-statements/m-p/717040#M671032 2014-10-13T21:29:15Z