Date Filter on Multiple Date Fields

qlikwiz123 — Sat, 16 Nov 2024 00:35:25 GMT

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.

Re: Date Filter on Multiple Date Fields

jwjackso — Thu, 28 May 2020 16:49:22 GMT

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.

topic Re: Date Filter on Multiple Date Fields in QlikView

Date Filter on Multiple Date Fields

Re: Date Filter on Multiple Date Fields