Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Here is my QVW