Table disappears in Qlik Sense when interpreting a date field
Hi there,
We're experiencing a recurring problem - when pulling data from a SQL Server, Qlik doesn't interpret the date field as a date. When we try to rectify this by using the interpreter function (Date#), the whole table disappears. We've accidentally had this issue on different machines and by different users, so it's not limited to my machine, it is something else.
End goal is quite simple - to put that date field in a Date Picker object. However, it appears we're missing something and we don't quite know what. We've even changed the default date format (through the script editor) to match the SQL Date format in the hope that this will help but to no avail.
I'm still unsure how or why the date fields messed up the table, but at least I know now how to process date fields on input (and I've learned about QVD files too 🙂 ).
