Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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]
))
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]
))