Skip to main content
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