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

    date less than or equal to date chosen

    Noha Salem

      hi,

       

      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