Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
eli1
Contributor
Contributor

Custom date picker filter

Hi everyone,

I would like to select a range of dates in the date picker to highlights objects in a table and take an evidence (screenshot) of it, but if I select a range in which in some days I have no items then these days are not shown in the range.
Below I show you an example (black days are the ones in which I received something, while the grey ones are those days in which I didn't receive anything):

eli1_0-1684141808364.png

So, if I want to select for example the range from 5 March to 11 March I would want to have "2023-03-05  -  2023-03-11" in the bar of the date picker, but I only get the 'black' days as shown in image below:

eli1_1-1684142104697.png

Can anyone please help me getting the whole interval and not only the one in which I received something in my database?

Thank you a lot!

Labels (1)
2 Replies
vikasmahajan

Hi,

you need to configure date range picker : 

Date range picker

https://www.youtube.com/watch?v=3N4XDj1gaAM

Regards

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
eli1
Contributor
Contributor
Author

Hi, 

thanks in advance for your help.

I tried to configure the range picker but I still have the same problem, I started to think it's a part of the Qlik implementation design. 
Just to be clearer, I set a connection with my DB and I need to show the results in the dataset into a table by selecting the data range in the data range picker (as in the example I made before). The fields shown in the table are correct, but I need to show the right data interval (the one I selected) and not the one in which I received data (automatically selected by the picker). I tried to set the 'Start date' and 'End date' in the configuration but it still doesn't work.

I don't know if it's possible to do it, anyway thank you again a lot!

Regards.