topic Re: if statement in QlikView https://community.qlik.com/t5/QlikView/if-statement/m-p/1138861#M894531 <HTML><HEAD></HEAD><BODY><P>If you are calling a column with spaces in the name, then this will have to be surrounded by square brackets;</P><P></P><P>if(Tree = 'Y', [Tree Name])</P><P></P><P>If using this statement in a text box, it will have to be proceeded with an equals. </P></BODY></HTML> Fri, 05 Aug 2016 11:16:39 GMT hartleyr 2016-08-05T11:16:39Z if statement https://community.qlik.com/t5/QlikView/if-statement/m-p/1138858#M894528 <HTML><HEAD></HEAD><BODY><P>my question is:</P><P></P><P>how do you write code that uses the field name with an If statement; </P><P>e.g. If tree = 'Y', then get the tree name from Tree Name column</P><P></P><P>IF(<SPAN style="font-size: 13.3333px;"> Tree = 'Y', Tree Name)</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/if-statement/m-p/1138858#M894528 Anonymous 2020-11-25T16:16:04Z Re: if statement https://community.qlik.com/t5/QlikView/if-statement/m-p/1138859#M894529 <HTML><HEAD></HEAD><BODY><P>Looks right to me. Is it not working?</P></BODY></HTML> Fri, 05 Aug 2016 11:09:51 GMT https://community.qlik.com/t5/QlikView/if-statement/m-p/1138859#M894529 sunny_talwar 2016-08-05T11:09:51Z Re: if statement https://community.qlik.com/t5/QlikView/if-statement/m-p/1138860#M894530 <HTML><HEAD></HEAD><BODY><P>try fro the same</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">IF(</SPAN><SPAN style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> Tree = 'Y', [Tree Name],[Tree Name])</SPAN></P></BODY></HTML> Fri, 05 Aug 2016 11:13:21 GMT https://community.qlik.com/t5/QlikView/if-statement/m-p/1138860#M894530 Chanty4u 2016-08-05T11:13:21Z Re: if statement https://community.qlik.com/t5/QlikView/if-statement/m-p/1138861#M894531 <HTML><HEAD></HEAD><BODY><P>If you are calling a column with spaces in the name, then this will have to be surrounded by square brackets;</P><P></P><P>if(Tree = 'Y', [Tree Name])</P><P></P><P>If using this statement in a text box, it will have to be proceeded with an equals. </P></BODY></HTML> Fri, 05 Aug 2016 11:16:39 GMT https://community.qlik.com/t5/QlikView/if-statement/m-p/1138861#M894531 hartleyr 2016-08-05T11:16:39Z Re: if statement https://community.qlik.com/t5/QlikView/if-statement/m-p/1138862#M894532 <HTML><HEAD></HEAD><BODY><P> I don't get the tree names.</P></BODY></HTML> Fri, 05 Aug 2016 12:15:34 GMT https://community.qlik.com/t5/QlikView/if-statement/m-p/1138862#M894532 Anonymous 2016-08-05T12:15:34Z Re: if statement https://community.qlik.com/t5/QlikView/if-statement/m-p/1138863#M894533 <HTML><HEAD></HEAD><BODY><P>it is now working; I surrounded the field name with quotation marks</P></BODY></HTML> Fri, 05 Aug 2016 12:22:38 GMT https://community.qlik.com/t5/QlikView/if-statement/m-p/1138863#M894533 Anonymous 2016-08-05T12:22:38Z