This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have data as shown below
When I derive Quarter, it is showing Q for DD/MM/YYYY. How to bring all the data into uniform format and eliminate Q.
Thanks in advance.
Add the following statement to the default environment variables on the qvw.
View solution in original post
use the Alt function to return the valid date
alt( date#( MyDate, 'YYYY/MM/DD' ),
date#( MyDate, 'MyDate MM/DD/YYYY' ),
date#( MyDate, 'MM/DD/YY' ),
'Not valid date' )
'Not valid date' ) as MyNewDate
You may extend it to as many formats as you think you could be loading 'MM-DD-YYYY', YYYY-MM-DD'
If this works please tag as resolved