8 Replies Latest reply: Oct 30, 2018 9:38 AM by Anil Samineni RSS

    Select a Cost at a point of time

    George Kouris

      Hi, i am new to Qlik Sense and I am trying to select a cost in point of time, and i cant seem to get the correct expression.

       

      So i have a list Average Cost, and what i need is based on the Selected date i want to return the max date average cost that is equal to or less to the selected date. I have tried the below, expression but i cannot get it to work.

      =if($(vSelectDate)=<[TransDate],max([TransDate],[TransDate]=<$(vSelectDate)),[TransDate])

      Any help would be appreciated.

      Capture.PNG

      Thanks

      George