2 Replies Latest reply: Dec 12, 2017 10:56 AM by Bebee Pastino RSS

    How to ignore selections in a table

    Bebee Pastino

      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)