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.
Hi All ,
I have an excel file with a date field. For other fields wherever there is blank I have used below expression so that I can select them from List box.
Make Blank values to Dummy variable:
IF(LEN(TRIM(FIELD))=0, 'UNSPECIFIED',FIELD) as FIELD
Now My question is how will apply something similar to above to a date field. I know one option would be to use a Dummy Date. Would it be possible I give the same Unspecified?
You could do something like this:
if(not isNum(Date),'UNSPECIFIED',date(Date,'MMM-DD-YYYY')) as Date
for the sample data provided in the xlsx file, it gives me the following
View solution in original post
Yes you can try or else you can add any dummy date that recognise as dummy date
IF(LEN(TRIM(FIELD))=0, 'UNSPECIFIED',Date(FIELD)) as FIELD
Thank you Felip
Glad it helped Surya