10 Replies Latest reply: May 31, 2017 11:44 AM by VICTOR HUGO DE SOUSA ROSA RSS

    Getting LAST value in the selected Date Range QLIK SENSE

    VICTOR HUGO DE SOUSA ROSA

      Hello guys!

       

      I need some help here! Data example:

       

      Store / Date / Stock($)

      1 / 2017-01-01 / 1

      2 / 2017-01-01 / 2

      1 / 2017-01-02 / 3

      2 / 2017-01-02 / 4

      1 / 2017-01-03 / 5

      2 / 2017-01-03 / 6


      User selected date range from 2017-01-01 to 2017-01-02

      I want to show only the last selected day sum(stock)


      Stock($) = 7


      I've tryed SUM( {< DATE = {'2017-01-02'} >} STOCK) and this worked, but how to do using "max_date_range variable"?

       

      Thanks!