QlikView App Dev

newqlik2017 · ‎2017-10-13

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!

newqlik2017 · ‎2017-10-13

Thanks Anil.

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

View solution in original post

Anil_Babu_Samineni · ‎2017-10-13

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 · ‎2017-10-13

Thanks Anil.

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

Anil_Babu_Samineni · ‎2017-10-13

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)

QlikView App Dev

filter a dimension column based on date