topic Re: Custom Date Filter in Integration, Extension & APIs

Custom Date Filter

oseimuduame — Thu, 15 Mar 2018 15:23:13 GMT

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

Re: Custom Date Filter

YoussefBelloum — Thu, 15 Mar 2018 16:27:35 GMT

Hi,

can you attach some rows from the data you have ?

Re: Custom Date Filter

Nagaraju_KCS — Thu, 15 Mar 2018 16:32:23 GMT

PFA,

Re: Custom Date Filter

YoussefBelloum — Thu, 15 Mar 2018 16:39:48 GMT

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

Re: Custom Date Filter

bobbiros — Thu, 15 Mar 2018 17:16:09 GMT

Take a look at the QlikSense Date Range Picker extension

Qlik Branch

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

Re: Custom Date Filter

oseimuduame — Thu, 15 Mar 2018 17:33:39 GMT

This is Qliksense i am currently running Qlikview

Re: Custom Date Filter

Nagaraju_KCS — Thu, 15 Mar 2018 17:34:11 GMT

Try this,

https://github.com/NOD507/SenseDateRangePicker

https://community.qlik.com/thread/162613

Re: Custom Date Filter

oseimuduame — Thu, 15 Mar 2018 17:34:28 GMT

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

Re: Custom Date Filter

oseimuduame — Thu, 15 Mar 2018 18:18:55 GMT

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