Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have got this strange behaviour while loading the data.
It is working on one of the QVW but it is not doing the job i wanted in the other QVW.
Requirement: I want to show only previous month data. in my case Until Sep' 2017.
I have used this in the load script ' where Date(Floor("recorded_at")) < MonthStart(today())'
It is working but not in other qvw . all the same fields and table.
Any help pls
regards,
Vamsi.
In the qvw where this doesn't work.... have you checked if QlikView reads your date field as date or text? May be you will need interpretation functions such as Date#() or TimeStamp#() to help qlikview understand your date and time field?