Date filter with variable

[Sany]

Hello,

In the scenario, the user would select a date. The records are refreshed and reflected in Qlik if the effective dates (a column in dataset) for those records are less than and equal to the user entered dates.

Can anybody suggest a solution for this?

Thanks,

Sany

[Vegar]

You can control this on expression/measure level using set analysis.

Assuming you have an measure like Sum(Value) and a date field named [Date], then you can add set analysis like this to get all previous dates.

Sum( {<Date={"<=$(=max(Date))"}>} Value)