topic Re: IF statement with GetFieldSelection in QlikView https://community.qlik.com/t5/QlikView/IF-statement-with-GetFieldSelection/m-p/821737#M289697 <HTML><HEAD></HEAD><BODY><P>=IF(SubStringCount(Concat(Distinct GetFieldSelections(YearSmall),'|'),'14/15') or SubStringCount(Concat(Distinct GetFieldSelections(Year),'|'),'2014'),30,'')</P></BODY></HTML> Fri, 12 Dec 2014 10:48:01 GMT MK_QSL 2014-12-12T10:48:01Z IF statement with GetFieldSelection https://community.qlik.com/t5/QlikView/IF-statement-with-GetFieldSelection/m-p/821735#M289695 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am trying to create an IF statement where a GetFieldSelections [YearSmall] <EM>includes</EM> '14/15' .</P><P></P><P>This seems straight forward when the GetFieldSelections is equal to '14/15' as below</P><P>=IF(GetFieldSelections(YearSmall) = '14/15' or GetFieldSelections(Year) = '2014',30)&nbsp; but this does not then work if multiple selections are made on [YearSmall]</P><P></P><P>Many thanks</P></BODY></HTML> Fri, 12 Dec 2014 10:40:40 GMT https://community.qlik.com/t5/QlikView/IF-statement-with-GetFieldSelection/m-p/821735#M289695 2014-12-12T10:40:40Z Re: IF statement with GetFieldSelection https://community.qlik.com/t5/QlikView/IF-statement-with-GetFieldSelection/m-p/821736#M289696 <HTML><HEAD></HEAD><BODY><P>If(index(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">GetFieldSelections(YearSmall), <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">'14/15')) &gt; 0</SPAN></SPAN></P></BODY></HTML> Fri, 12 Dec 2014 10:46:14 GMT https://community.qlik.com/t5/QlikView/IF-statement-with-GetFieldSelection/m-p/821736#M289696 yduval75 2014-12-12T10:46:14Z Re: IF statement with GetFieldSelection https://community.qlik.com/t5/QlikView/IF-statement-with-GetFieldSelection/m-p/821737#M289697 <HTML><HEAD></HEAD><BODY><P>=IF(SubStringCount(Concat(Distinct GetFieldSelections(YearSmall),'|'),'14/15') or SubStringCount(Concat(Distinct GetFieldSelections(Year),'|'),'2014'),30,'')</P></BODY></HTML> Fri, 12 Dec 2014 10:48:01 GMT https://community.qlik.com/t5/QlikView/IF-statement-with-GetFieldSelection/m-p/821737#M289697 MK_QSL 2014-12-12T10:48:01Z Re: IF statement with GetFieldSelection https://community.qlik.com/t5/QlikView/IF-statement-with-GetFieldSelection/m-p/821738#M289698 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=IF(GetFieldSelections(YearSmall) = '14/15' and GetFieldSelections(Year) = '2014',30) </SPAN></P></BODY></HTML> Fri, 12 Dec 2014 10:54:52 GMT https://community.qlik.com/t5/QlikView/IF-statement-with-GetFieldSelection/m-p/821738#M289698 SunilChauhan 2014-12-12T10:54:52Z