How to show the data until last month - Qlik Community

Anonymous · ‎2017-03-22

Hi,

I have a requirement to pull the data until the last day of the month.

Any idea how to do that on load script ?

Anil_Babu_Samineni · ‎2017-03-22

May be using Monthend() from where condition

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

vinieme12 · ‎2017-03-22

you can either do

Year(Datefield) <= Year(Today()) AND Datefield<= monthend(today()-day(today()))

or simply

Year(Datefield) <= Year(Today()) AND Month(Datefield) <= Month(Today())

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.