Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
newqlik2017
Contributor

filter a dimension column based on date

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!

1 Solution

Accepted Solutions
newqlik2017
Contributor

Re: filter a dimension column based on date

Thanks Anil.

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

3 Replies

Re: filter a dimension column based on date

May be look about Adhoc Reports?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
newqlik2017
Contributor

Re: filter a dimension column based on date

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

Great, Then close this thread

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)