How to ignore selections in a table

[bebee727]

Hello,

I'm using Qlik Sense.  I have a variable to pull the Max of a field YR_MO (vCurrentMonth).   I want to have a table have the data frozen on the most recent YR_MO.  Here is the formula I'm using.   When users are selecting YR_MO for previous months on other sheets, this sheet changes with the selection.  Thanks

Count({<YR_MO={'$(vCurrentMonth)'}>}CTR_NO)

[sunny_talwar · Accepted solution]

What is the expression you use for vCurrentMonth? If you use an expression like this Max(YR_MO), then change it to this

Max({1} YR_MO)

[bebee727]

That did it!!  Thankyou.. I've spent the last hour trying to figure it out on my own.  Thanks for your help.