topic How to get specific data type? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-specific-data-type/m-p/1391067#M422926 <HTML><HEAD></HEAD><BODY><P>I have field where its values are of combination of char,varchar and int data type, i want to get only char data type of that field in my listbox?</P></BODY></HTML> Tue, 14 Nov 2017 17:17:54 GMT baarathi 2017-11-14T17:17:54Z How to get specific data type? https://community.qlik.com/t5/QlikView/How-to-get-specific-data-type/m-p/1391067#M422926 <HTML><HEAD></HEAD><BODY><P>I have field where its values are of combination of char,varchar and int data type, i want to get only char data type of that field in my listbox?</P></BODY></HTML> Tue, 14 Nov 2017 17:17:54 GMT https://community.qlik.com/t5/QlikView/How-to-get-specific-data-type/m-p/1391067#M422926 baarathi 2017-11-14T17:17:54Z Re: How to get specific data type? https://community.qlik.com/t5/QlikView/How-to-get-specific-data-type/m-p/1391068#M422927 <HTML><HEAD></HEAD><BODY><P>try</P><P></P><P><A name="kanchor1269"></A>Logical functions</P><DIV>This section describes functions handling logical operations. All functions can be used in both the load script and in chart expressions.</DIV><DIV class="MCDropDown_Open MCDropDown dropDown"><SPAN class="MCDropDownHead dropDownHead"><A class="dropDownHotspot dropDownHotspotstatement MCDropDownHotSpot MCDropDownHotSpot_"><IMG alt="Closed" class="jive-image MCDropDown_Image_Icon" data-mc-alt2="Open" height="13" src="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Skins/Default/Stylesheets/Images/transparent.gif" width="16" />IsNum</A></SPAN>&nbsp;&nbsp; <DIV>Returns -1 (True) if the expression can be interpreted as a number, otherwise 0 (False).</DIV><DIV class="syntax" data-mc-conditions="Primary.NotToTranslate"><A name="kanchor1270"></A><A name="IsNum"></A>IsNum( expr )</DIV></DIV><DIV class="MCDropDown_Open MCDropDown dropDown"><SPAN class="MCDropDownHead dropDownHead"><A class="dropDownHotspot dropDownHotspotstatement MCDropDownHotSpot MCDropDownHotSpot_"><IMG alt="Closed" class="jive-image MCDropDown_Image_Icon" data-mc-alt2="Open" height="13" src="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Skins/Default/Stylesheets/Images/transparent.gif" width="16" />IsText</A></SPAN>&nbsp;&nbsp; <DIV>Returns -1 (True) if the expression has a text representation, otherwise 0 (False). </DIV><DIV class="syntax" data-mc-conditions="Primary.NotToTranslate"><A name="kanchor1271"></A><A name="IsText"></A>IsText( expr )</DIV></DIV></BODY></HTML> Tue, 14 Nov 2017 17:22:18 GMT https://community.qlik.com/t5/QlikView/How-to-get-specific-data-type/m-p/1391068#M422927 jpenuliar 2017-11-14T17:22:18Z Re: How to get specific data type? https://community.qlik.com/t5/QlikView/How-to-get-specific-data-type/m-p/1391069#M422928 <HTML><HEAD></HEAD><BODY><P>sir should i do this in scripting or can give it as expression while creating listbox?</P></BODY></HTML> Tue, 14 Nov 2017 17:25:07 GMT https://community.qlik.com/t5/QlikView/How-to-get-specific-data-type/m-p/1391069#M422928 baarathi 2017-11-14T17:25:07Z Re: How to get specific data type? https://community.qlik.com/t5/QlikView/How-to-get-specific-data-type/m-p/1391070#M422929 <HTML><HEAD></HEAD><BODY><P>You can do it in both - Chart expression and script expression.</P></BODY></HTML> Tue, 14 Nov 2017 17:32:30 GMT https://community.qlik.com/t5/QlikView/How-to-get-specific-data-type/m-p/1391070#M422929 sonkumamon 2017-11-14T17:32:30Z Re: How to get specific data type? https://community.qlik.com/t5/QlikView/How-to-get-specific-data-type/m-p/1391071#M422930 <HTML><HEAD></HEAD><BODY><P>Hi Baarathi V,</P><P></P><P>It is ideal to have it in the script if you are particular with performance.</P><P>Its also possible to do in the listbox object, however if you have millions of rows and will use that calculated listbox as filter to all sheets you have, you have a potential performance issue</P></BODY></HTML> Tue, 14 Nov 2017 17:34:17 GMT https://community.qlik.com/t5/QlikView/How-to-get-specific-data-type/m-p/1391071#M422930 jpenuliar 2017-11-14T17:34:17Z