filter a dimension column based on date

[newqlik2017]

Hello,

What are the best ways to filter out data from a chart based on a Date (column) dimension?

I attached a sample QVW. I'm trying to create multiple charts for a company column based on different dates. Currently, I've a hardcoded filter on the Date dimension at each chart. Goal is not to have a hard coded date value but to automatically reduce the data set for the given date period.

Thanks!

[Anil_Babu_Samineni]

May be look about Adhoc Reports?

[newqlik2017 · Accepted solution]

Thanks Anil.

I was able to get the desired result using set analysis in the expression with max() function.

[Anil_Babu_Samineni]

Great, Then close this thread