Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
oseimuduame
Contributor 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
Esteemed Contributor

Re: Custom Date Filter

Hi,

can you attach some rows from the data you have ?

qv_testing
Valued Contributor II

Re: Custom Date Filter

PFA,

YoussefBelloum
Esteemed Contributor

Re: Custom Date Filter

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
New Contributor II

Re: Custom Date Filter

Take a look at the QlikSense Date Range Picker extension

Qlik Branch

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

oseimuduame
Contributor II

Re: Custom Date Filter

This is Qliksense i am currently running Qlikview

qv_testing
Valued Contributor II

Re: Custom Date Filter

oseimuduame
Contributor II

Re: Custom Date Filter

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

oseimuduame
Contributor II

Re: Custom Date Filter

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

Community Browser