1 Reply Latest reply: Oct 3, 2016 5:51 PM by Noha Salem RSS

    date less than or equal to date chosen



      Now today problem is complicated


      currently I have a sheet that contains historical data for a warehouse and I am creating a grid that should show all dates less than or equal to chosen date when they have values


      so if the owner looks at the sheet and chooses 1 august 2016 from date filters and there are items haven't moved since 2 june 2016 I want that value to show on the table.

      pic 6.PNG

      any ideas how to achieve that . plus putting inconsideration that the item has more than one entry and I want to see the latest action only.


      the filters and dates in the sheet comes from one field which is called [OnHand History Transaction.AsOfDate]


      thanks in advance


      qlik sense