Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ks20
Contributor III
Contributor III

Selection based on dates


Hello Community,

I have a scenario where I want all my tables and charts to display data based on the maximum date value. However, I also need the flexibility to apply date, month, and year filters to view specific data according to those filters. The current formula I am using is working correctly, but I believe there might be a more efficient way to achieve this. Any suggestions would be highly appreciated. Thank you!

Measure: 

if(GetSelectedCount(Daily)+GetSelectedCount(MonthYear)+GetSelectedCount(Weekly)+GetSelectedCount(Year)>0,
Sum(calls),

Sum(calls))

1 Reply
Lisa_Sun
Support
Support

You can refer to Solved: Peek with Dates - Qlik Community - 906847

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!