Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

date less than or equal to date chosen

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

1 Solution

Accepted Solutions
Not applicable

Re: date less than or equal to date chosen

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]

))

1 Reply
Not applicable

Re: date less than or equal to date chosen

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]

))