End of Month data

[akrueger]

When my data loads I only want data from end of previous month to display. Right now it is displaying anything as of the last time the report was updated. For example, if the data is updated 01-03-23. I only want my report to display data as of 12-31-22. 

[Vegar]

Assuming you have a date or timestamp field to filter your load on, then you can do this.

LOAD FieldA, FieldB, DateField, etc

FROM Source

WHERE DateField < monthstart(today())

[akrueger]

Can this be done directly in the expression as I'm using Qlik through QuickBooks?