I am loading some fields including dates in QlikView.
When I am loading this without adding any filter conditions (i.e where clause), then it's loading perfectly as timestamp values, not numeric ones.
But, when I am using a where clause, in load for filtering data only from 2017 onwards, then it is converting all timestamp values in numbers.
Can anyone please tell me what's wrong here?
not sure what your script looks like.
You may want to try like this to avoid unwanted conversions of fields datatypes.
where Year(Date) >=2017; //if you want to filter on date then use : where Date#(Date) >=Date#(YourDesiredDate).
if this doesnt work out for you,post your sample qvw or sample data.