Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Neda
Contributor
Contributor

Load date from sql server returns strange character

Dear all,

I'm loading data from a qvd file generated from a sql server database. However the value for one of the date fields sometimes is set to '-' but when I apply isnull() or len(trim()) both functions return null themselves! I've tried different functions but all returns nothing e.g. ord() function returns null as well.

just wondering this is something related to how sql server stores null for date and how it can be handled in the script.

Thanks is advance.

 

Labels (1)
1 Reply
Brett_Bleess
Former Employee
Former Employee

The first question is the issue actually in the SQL DB, or do you think it is in your QlikView Load Script?  If the SQL DB is formatting something oddly, you will have to account for that in the Load Script to ensure you get what you want in the date field in that case.  I would suspect others have not answered due to confusion over where the issue starts, if you can update to provide that info, then others may have some further suggestions.  

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.