https://community.qlik.com/t5/App-Development/GetFieldselections-not-working-with-AND-Condition-though-working/m-p/1774060#M59941 <P>Hi All,</P><P>&nbsp;</P><P>GetFieldselections not working with AND Condition though working with OR Condition</P><P>=If(GetFieldselections(Crop)='Tomato' and GetFieldselections(Species)='Tomato',1,0)</P><P>&nbsp;</P><P>Please Help!</P> Sat, 16 Nov 2024 00:50:07 GMT VaishnaviC 2024-11-16T00:50:07Z https://community.qlik.com/t5/App-Development/GetFieldselections-not-working-with-AND-Condition-though-working/m-p/1774060#M59941 <P>Hi All,</P><P>&nbsp;</P><P>GetFieldselections not working with AND Condition though working with OR Condition</P><P>=If(GetFieldselections(Crop)='Tomato' and GetFieldselections(Species)='Tomato',1,0)</P><P>&nbsp;</P><P>Please Help!</P> Sat, 16 Nov 2024 00:50:07 GMT https://community.qlik.com/t5/App-Development/GetFieldselections-not-working-with-AND-Condition-though-working/m-p/1774060#M59941 VaishnaviC 2024-11-16T00:50:07Z https://community.qlik.com/t5/App-Development/GetFieldselections-not-working-with-AND-Condition-though-working/m-p/1774165#M59953 <P>Hi,</P><P>Its working fine as there is no issue in the syntax.</P><P>It might be that the data have space or something. use trim() for removing extra space or len() to calculate the size of selected value. yor will get to know the cause of it.</P><P>Regards,</P><P>Prashant&nbsp;</P> Wed, 13 Jan 2021 18:45:36 GMT https://community.qlik.com/t5/App-Development/GetFieldselections-not-working-with-AND-Condition-though-working/m-p/1774165#M59953 Prashant_N 2021-01-13T18:45:36Z