Incorrect Date range evaluation Set Analysis

[Mputsoe2023]

Good day,

I came across some interesting behavior on how my Qliksense table chart script evaluates the date ranges. Here is my script below:

My data model has date up to December 2024, but as you might see on my screenshot, I am only interested in records between October 2023 and Dec 2023. However, even though my syntax appears to be correct, my table chart still returns everything from October 2023 to December 2024.

My data is from a single SQL table and not joined to anything else and I made sure that my date (Month_Year) column is indeed a date data type.

What am I missing here?

[maheshkuttappa · Accepted solution]

Your syntax seems to be correct, try removing the space between "<= " and $(=AddMonths(Max(Month_Year)-12). 

Your expression <=   $(=AddMonths(Max(Month_Year)-12) change it to <=$(=AddMonths(Max(Month_Year)-12) 

[maheshkuttappa]

Please mark the solution as correct, This will help others with a similar issue  

[Mputsoe2023]

Hahahahaha!! I was definitely blind to that!   Thank you so much @maheshkuttappa !