Discussion board where members can get started with Qlik Sense.
I have a problem for counting records lower of a data of last year.
I have try:
but don't work.
where Data1ago is a variable so defined =Date(AddYears(Today(), -1))
Could anyone help me? Thank you
The problem is that your variable isn't executed, try this:
Besides this, you can expect some problems with your date format when it's not correct. The best thing to do would be to floor all your dates.
// Add this in your script
Floor([Mydata.autoCalendar.Date]) as [Mydata.autoCalendar.Date]
// and floor your variable
Date1ago = Floor(Date(AddYears(Today(), -1)))
View solution in original post