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

          2021,

          2021

          2022

      ];

       

      Thanks in advance!