Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
bebee727
New Contributor II

How to ignore selections in a table

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)

Tags (1)
1 Solution

Accepted Solutions

Re: How to ignore selections in a table

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)

2 Replies

Re: How to ignore selections in a table

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
New Contributor II

Re: How to ignore selections in a table

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