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

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/hi...

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

 
 
 

qlikwiz123_0-1590527607522.png

 

 
 

 

 

 

Labels (2)
2 Replies
chrismarlow
Specialist II
Specialist II

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;

20200527_2.png

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

20200527_3.png

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

Cheers,

Chris.

qlikwiz123
Creator III
Creator III
Author

@chrismarlow 

Here is my QVW