Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm a bit new to qlik and am building a report template. I have created a filter which has a search expression as follows:
= (DueDate >= Date('01/02/2024') AND DueDate <= Date('29/02/2024'))
Is there a way to make this dynamic so that I don't have to hardcode the previous month like above etc?
Thanks for any help!
see it like this
$(=(MonthStart(Date((Today(1))),-1) )) - '01/02/2024'
$(=(MonthEnd(Date((today(1))),-1))) - '29/02/2024'
Regarts, Matheus