Hi all- I'm trying to limit the load of my data based on date and Qlik is just completely ignoring it- I'm so confused. I've tried all sort of combos of date() and num() etc and nothing works- it keeps ignoring my where clause and loading the full data set. Help? Any ideas? the reducing field is a normal date format (MM/DD/YYYY) and I've tried what I usually use
'WHERE datefield >= makedate(2016,10,1)' as well as WHERE datefield >= '10/1/2016' to no avail.
If it's an issue with format interpretation I haven't been able to figure out what exactly the problem is. I have a test field in the data itself that basically puts that where clause as an if statement flag field, and the result is as expected- so why won't it work in the load?
Visually your field looks like a date field, but it's probably interpretated by Qlik like a string. Convert your field and then apply the formatting date : Date(Date#(Field),'MM/DD/YYYY'). After that, your filter will work.