Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikwiz123
Creator III
Creator III

Date Filter on Multiple Date Fields

I have a table with multiple date fields

DateA, DateB, DateC, DateD, DateE, DateF

I need to create a filter - a Text box maybe with

Filter -  'Today', 'Yesterday', 'This Week', 'Last Week', 'Last Two Weeks', 'This Month', 'Last Month', 'Last Two Months', 'This Year', 'Last Year',

When I select any value, that should apply on all date fields. 

Labels (3)
1 Reply
jwjackso
Specialist III
Specialist III

Check out the Canonical Date .  If you don't use the [date type] in your calculation, I think you will reference all dates on the record.