topic Re: How to convert text values which are in the database to numeric values in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-text-values-which-are-in-the-database-to-numeric/m-p/544963#M203531 <HTML><HEAD></HEAD><BODY><P>Thank you so much</P></BODY></HTML> Fri, 11 Oct 2013 08:43:31 GMT ferha_jafri 2013-10-11T08:43:31Z How to convert text values which are in the database to numeric values https://community.qlik.com/t5/QlikView/How-to-convert-text-values-which-are-in-the-database-to-numeric/m-p/544961#M203529 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P></P><P>The issue i am facing is there are two fields as year and month in the database which are saved in the database in text format although in qlikview it is showing as numeric but numeric functions are not working on these fields as max, it is very urgent.</P><P></P><P>Thanks in advance</P><P>Ferha Jafri</P></BODY></HTML> Fri, 11 Oct 2013 07:48:06 GMT https://community.qlik.com/t5/QlikView/How-to-convert-text-values-which-are-in-the-database-to-numeric/m-p/544961#M203529 ferha_jafri 2013-10-11T07:48:06Z Re: How to convert text values which are in the database to numeric values https://community.qlik.com/t5/QlikView/How-to-convert-text-values-which-are-in-the-database-to-numeric/m-p/544962#M203530 <HTML><HEAD></HEAD><BODY><P>You can use the num# function to create numbers from text. If you want to convert strings to dates you can use the date# function. For timestamps (aka datetime) there's the timestamp# function. All these functions accept a format string as second parameter to specify how the string should be parsed.</P><P></P><P>num#('234.46', '##0.00')</P><P>date#('2013 Jan 25', 'YYYY MMM DD')</P><P>timestamp#('20131011 11:12:45.321 AM', 'YYYYMMDD hh:mm:ss.fff TT')</P><P></P><P>See the help file for more details.</P></BODY></HTML> Fri, 11 Oct 2013 08:18:34 GMT https://community.qlik.com/t5/QlikView/How-to-convert-text-values-which-are-in-the-database-to-numeric/m-p/544962#M203530 Gysbert_Wassenaar 2013-10-11T08:18:34Z Re: How to convert text values which are in the database to numeric values https://community.qlik.com/t5/QlikView/How-to-convert-text-values-which-are-in-the-database-to-numeric/m-p/544963#M203531 <HTML><HEAD></HEAD><BODY><P>Thank you so much</P></BODY></HTML> Fri, 11 Oct 2013 08:43:31 GMT https://community.qlik.com/t5/QlikView/How-to-convert-text-values-which-are-in-the-database-to-numeric/m-p/544963#M203531 ferha_jafri 2013-10-11T08:43:31Z