Skip to main content
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.