date less than or equal to date chosen

[#1]

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.

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

[#2 · Accepted solution]

the answer to this one is

max(if([OnHand History Transaction.AsOfDate]<=makedate([Historical Year.Year],[Historical Month.Month],[Historical Day.Day]),

[OnHand History Transaction.AsOfDate]

))