Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
can you attach some rows from the data you have ?
PFA,
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
Take a look at the QlikSense Date Range Picker extension
< http://branch.qlik.com/#!/project/5697a878dcc497f80ed514bf >
This is Qliksense i am currently running Qlikview
can you shed more light Please i dont seems to understand.
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