Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
oseimuduame
Creator II
Creator II

Custom Date Filter

Good Afternoon Guys,

i have a report that i am currently working on but i have been using Lists for my Date Range.. Year, Month and Day. But i want to have a Date Range that will be like FROM and TO DATE... For Example i want to have two filter that will filter FROM a particular date TO another DATE...

Any help Please.

Thank You

8 Replies
YoussefBelloum
Champion
Champion

Hi,

can you attach some rows from the data you have ?

qv_testing
Specialist II
Specialist II

PFA,

YoussefBelloum
Champion
Champion

I just used the Date#() and Date() functions to evalue your date as a Date field and format it the right way.

what you want, you have it already with these Object above your table no ?

PFA

bobbiros
Contributor III
Contributor III

Take a look at the QlikSense Date Range Picker extension

Qlik Branch

< http://branch.qlik.com/#!/project/5697a878dcc497f80ed514bf >

Bob Biros
oseimuduame
Creator II
Creator II
Author

This is Qliksense i am currently running Qlikview

oseimuduame
Creator II
Creator II
Author

can you shed more light Please i dont seems to understand.

oseimuduame
Creator II
Creator II
Author

Hello guys,

I just figured this out now by following the step below;

1. I created two variables vStart and vEnd, i then use 2 Calender Object

2. I changed the Input style to Calender

3. Changed the First Calender Data to Variables and Select vStart and also do the same for the other Calender.

4. i Set my Min Value to =Min({1} INVC_DATE) and Max Value to =Max({1} INVC_DATE)

Note: INVC_DATE is the date i want to filter.

Check the video attached for more.... thanks Guys

Selecting Arbitrary Date Ranges - YouTube