Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.