topic Re: How to write Nested If in Set Analysis? in App Development https://community.qlik.com/t5/App-Development/How-to-write-Nested-If-in-Set-Analysis/m-p/1061812#M17118 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply.</P><P></P><P>I am using it as Dimension, so i used the above one.It works fine.</P><P></P><P>Thanks for the reply.</P></BODY></HTML> Tue, 03 May 2016 09:27:57 GMT 2016-05-03T09:27:57Z How to write Nested If in Set Analysis? https://community.qlik.com/t5/App-Development/How-to-write-Nested-If-in-Set-Analysis/m-p/1061809#M17115 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a query like </P><P></P><P>=IF(MajorSiteRegion in ('3.P.L','Corus','Fremont','India','Livermore','Metryx','San Jose','Silfex','Tualatin','Villach'),MajorSiteRegion)</P><P></P><P>In Qlikview it wont allow IN function. How to write the same in Set Analysis or any other alternate way..</P><P></P><P>Sub2u444&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Tue, 03 May 2016 09:00:14 GMT https://community.qlik.com/t5/App-Development/How-to-write-Nested-If-in-Set-Analysis/m-p/1061809#M17115 2016-05-03T09:00:14Z Re: How to write Nested If in Set Analysis? https://community.qlik.com/t5/App-Development/How-to-write-Nested-If-in-Set-Analysis/m-p/1061810#M17116 <HTML><HEAD></HEAD><BODY><P>Not sure where you are doing this. Is there any aggregation? If not then may using Match or WildMatch function:</P><P></P><P><STRONG>If(Match(MajorSiteRegion, </STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>'3.P.L', 'Corus', 'Fremont', 'India', 'Livermore', 'Metryx', 'San Jose', 'Silfex', 'Tualatin', 'Villach'), </STRONG><SPAN style="font-size: 13.3333px;"><STRONG>MajorSiteRegion)</STRONG></SPAN></SPAN></P></BODY></HTML> Tue, 03 May 2016 09:02:17 GMT https://community.qlik.com/t5/App-Development/How-to-write-Nested-If-in-Set-Analysis/m-p/1061810#M17116 sunny_talwar 2016-05-03T09:02:17Z Re: How to write Nested If in Set Analysis? https://community.qlik.com/t5/App-Development/How-to-write-Nested-If-in-Set-Analysis/m-p/1061811#M17117 <HTML><HEAD></HEAD><BODY><P>And if you're talking about set analysis then you can use something like:</P><P></P><P>count({&lt;MajorSiteRegion={'3.P.L','Corus','Fremont','India','Livermore','Metryx','San Jose','Silfex','Tualatin','Villach'}&gt;} distinct MajorSiteRegion)</P><P></P><P>That means count the distinct values of MajorSiteRegion that match the values in the list. This useless example should return 10.</P></BODY></HTML> Tue, 03 May 2016 09:21:56 GMT https://community.qlik.com/t5/App-Development/How-to-write-Nested-If-in-Set-Analysis/m-p/1061811#M17117 Gysbert_Wassenaar 2016-05-03T09:21:56Z Re: How to write Nested If in Set Analysis? https://community.qlik.com/t5/App-Development/How-to-write-Nested-If-in-Set-Analysis/m-p/1061812#M17118 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply.</P><P></P><P>I am using it as Dimension, so i used the above one.It works fine.</P><P></P><P>Thanks for the reply.</P></BODY></HTML> Tue, 03 May 2016 09:27:57 GMT https://community.qlik.com/t5/App-Development/How-to-write-Nested-If-in-Set-Analysis/m-p/1061812#M17118 2016-05-03T09:27:57Z