Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thank you so much