7 Replies Latest reply: Jul 14, 2018 9:16 PM by Robert Campbell RSS

    How would you show the last value possible?

    Miguel Rijk

      Hi All,


      - Qlik Sense -


      How would you solve this in an expression? I have 2 columns both year and value. Not all years have a value.  If I select a year without value, I would like to show then the last possible value available.


      Example. if I select 2022, then it would show 2134. This is the last possible value available. Same for 2021. However, when I select 2019, then it would show the correct value which is 321.


      LOAD * INLINE [

          Year, Value

          2018, 1000

          2019, 321

          2020, 2134






      Thanks in advance!