Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
newqlik2017
Creator II
Creator II

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
Creator II
Creator II
Author

Thanks Anil.

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

View solution in original post

3 Replies
Anil_Babu_Samineni

May be look about Adhoc Reports?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
newqlik2017
Creator II
Creator II
Author

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful