I am new to QLikView. I need to load data from a txt file and put a condition 'where' on the date. The field INV_DATE is in format 2-7-2010 0:00:00. So when I try to edit script after load code it doesnt give me desired results.
INV_DATE > '01-01-2009'
INV_DATE > '01/01/2009'
WHERE INV_DATE > '01-01-2009 0:00:00'
I have tried all possible combinations but I am not able to get results. Please help.
I have loaded the data succesfully. What I need to do as a next step, give user an option on the tool to give a date range and see the output for that date range. The date range will be in DDMMYYYY format.