topic What is a good alternative to Nested IF in chart expression? in QlikView https://community.qlik.com/t5/QlikView/What-is-a-good-alternative-to-Nested-IF-in-chart-expression/m-p/980301#M334682 <HTML><HEAD></HEAD><BODY><P>I have two charts to display TRENDS and ATTRITION. Three drivers for these charts are Scenario, Period and Perspective. There are 5 scenarios [A,B,C,D,E], 4 period [YTD, Month, Quarter, Half-Year] and 5 perspectives [Organization, Level, Grade, City, Technology] that work as combination to display these two charts. Period is common between both charts.</P><P></P><P>TRENDS Chat therefore has 20 combinations of Scenario + Period as nested IF with different expression. Simultaneously ATTRITION chart will display one perspective at a time with the same Period as in TREND chart for the given scenario on TREND chart. We end up with 100 nested IFs in the bottom chart. Ex: Level wise Attrition % [Perspective] plotted by dimension Month [Period] for all employee limited to C [Scenario].</P><P></P><P>I guess using nested IF in this kind of scenario may not possibly be the best solution. Appreciate and welcome your suggestions of any alternate approach.</P></BODY></HTML> Wed, 23 Dec 2015 16:08:20 GMT 2015-12-23T16:08:20Z What is a good alternative to Nested IF in chart expression? https://community.qlik.com/t5/QlikView/What-is-a-good-alternative-to-Nested-IF-in-chart-expression/m-p/980301#M334682 <HTML><HEAD></HEAD><BODY><P>I have two charts to display TRENDS and ATTRITION. Three drivers for these charts are Scenario, Period and Perspective. There are 5 scenarios [A,B,C,D,E], 4 period [YTD, Month, Quarter, Half-Year] and 5 perspectives [Organization, Level, Grade, City, Technology] that work as combination to display these two charts. Period is common between both charts.</P><P></P><P>TRENDS Chat therefore has 20 combinations of Scenario + Period as nested IF with different expression. Simultaneously ATTRITION chart will display one perspective at a time with the same Period as in TREND chart for the given scenario on TREND chart. We end up with 100 nested IFs in the bottom chart. Ex: Level wise Attrition % [Perspective] plotted by dimension Month [Period] for all employee limited to C [Scenario].</P><P></P><P>I guess using nested IF in this kind of scenario may not possibly be the best solution. Appreciate and welcome your suggestions of any alternate approach.</P></BODY></HTML> Wed, 23 Dec 2015 16:08:20 GMT https://community.qlik.com/t5/QlikView/What-is-a-good-alternative-to-Nested-IF-in-chart-expression/m-p/980301#M334682 2015-12-23T16:08:20Z Re: What is a good alternative to Nested IF in chart expression? https://community.qlik.com/t5/QlikView/What-is-a-good-alternative-to-Nested-IF-in-chart-expression/m-p/980302#M334683 <HTML><HEAD></HEAD><BODY><P>Use different expressions and use the conditional display condition to show hide them depending on the selections in the driver fields. See this blog post for more information: <A href="http://qlikviewcookbook.com/2014/12/how-not-to-choose-an-expression/" title="http://qlikviewcookbook.com/2014/12/how-not-to-choose-an-expression/">How Not to Choose an Expression | Qlikview Cookbook</A>‌. You could also create an excel file with the expressions and load the expressions in a field like explained in this blog post: <A href="http://qlikviewcookbook.com/2014/12/how-to-choose-an-expression/" title="http://qlikviewcookbook.com/2014/12/how-to-choose-an-expression/">How to Choose an Expression | Qlikview Cookbook</A></P></BODY></HTML> Wed, 23 Dec 2015 17:28:18 GMT https://community.qlik.com/t5/QlikView/What-is-a-good-alternative-to-Nested-IF-in-chart-expression/m-p/980302#M334683 Gysbert_Wassenaar 2015-12-23T17:28:18Z