topic Re: Date Filter on Multiple Date Fields in QlikView

Date Filter on Multiple Date Fields

qlikwiz123 — Sat, 16 Nov 2024 00:36:10 GMT

I have a table with multiple date fields

DateA,

DateB,

DateC,

DateD

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.

I have tried to implement ways shown here :https://community.qlik.com/t5/New-to-QlikView/Date-selections-on-Multiple-Date-fields/m-p/1700532/highlight/false#M388902

But they just add values in the fields instead of creating a filter

Re: Date Filter on Multiple Date Fields

chrismarlow — Wed, 27 May 2020 19:50:51 GMT

Hi,

On the old thread there was a suggestion that you post up a sample app. If you can't do that then maybe you can share your code - as I've dropped @Saravanan_Desingh code into a fresh QV & it looks pretty good. I would make a little change that this needs to pick up the range of dates in use to feed into row 41 below;

Otherwise you do get dates >135 days before today in the Name field & the ranges don't pick up;

Otherwise it looks pretty handy though & I look forward to using the ideas from it 😀

Cheers,

Chris.

Re: Date Filter on Multiple Date Fields

qlikwiz123 — Thu, 28 May 2020 14:23:03 GMT

@chrismarlow

Here is my QVW