topic Re: filter a dimension column based on date in QlikView

filter a dimension column based on date

newqlik2017 — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: filter a dimension column based on date

Anil_Babu_Samineni — Fri, 13 Oct 2017 15:42:02 GMT

May be look about Adhoc Reports?

Re: filter a dimension column based on date

newqlik2017 — Fri, 13 Oct 2017 18:47:05 GMT

Thanks Anil.

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

Re: filter a dimension column based on date

Anil_Babu_Samineni — Sat, 14 Oct 2017 02:52:36 GMT

Great, Then close this thread