How to pull last months data?

[Anonymous]

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.

[sunny_talwar]

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?