topic Variables returning either numeric or text value in QlikView https://community.qlik.com/t5/QlikView/Variables-returning-either-numeric-or-text-value/m-p/220339#M500591 <HTML><HEAD></HEAD><BODY><P>Hello Rich,</P><P>When the variable stores a literal string, it doesn't need to evaluate it, so you can call it without expanding.</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=if(zz_Display='Annual',100,0)</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope that helps.</P></BODY></HTML> Thu, 17 Feb 2011 15:14:29 GMT Miguel_Angel_Baeyens 2011-02-17T15:14:29Z Variables returning either numeric or text value https://community.qlik.com/t5/QlikView/Variables-returning-either-numeric-or-text-value/m-p/220338#M500590 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>Have been able to define a number of variables.</P><P>When using predefined numeric values, I am able to extract this value and evaluate it appropriately.</P><P>HOWEVER, when using text values as a pre-defined list, I am unable to evaluate whether a particular condition has been met.</P><P>Please see attached file for clarification...</P><P>Anyone have any ideas?</P><P>Please advise,</P><P>Kind regards,</P><P>Rich</P></BODY></HTML> Thu, 17 Feb 2011 15:06:39 GMT https://community.qlik.com/t5/QlikView/Variables-returning-either-numeric-or-text-value/m-p/220338#M500590 2011-02-17T15:06:39Z Variables returning either numeric or text value https://community.qlik.com/t5/QlikView/Variables-returning-either-numeric-or-text-value/m-p/220339#M500591 <HTML><HEAD></HEAD><BODY><P>Hello Rich,</P><P>When the variable stores a literal string, it doesn't need to evaluate it, so you can call it without expanding.</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=if(zz_Display='Annual',100,0)</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope that helps.</P></BODY></HTML> Thu, 17 Feb 2011 15:14:29 GMT https://community.qlik.com/t5/QlikView/Variables-returning-either-numeric-or-text-value/m-p/220339#M500591 Miguel_Angel_Baeyens 2011-02-17T15:14:29Z