How to convert text values which are in the database to numeric values

[ferha_jafri]

Hello Everyone,

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.

Thanks in advance

Ferha Jafri

[Gysbert_Wassenaar · Accepted solution]

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.

num#('234.46', '##0.00')

date#('2013 Jan 25', 'YYYY MMM DD')

timestamp#('20131011 11:12:45.321 AM', 'YYYYMMDD hh:mm:ss.fff TT')

See the help file for more details.

[ferha_jafri]

Thank you so much