Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Siercito
Partner - Contributor
Partner - Contributor

Filter pane - Date Range Help

Hi, sorry if my English is not that good.

I have a "Fecha vigencia hasta" in DD-MM-YYYY format. I want to put that in a filter pane with a specifically Date Range.

The filter need to show all the days before today since data generated and 45 days to the future.

I'm struggling with this because I'm new.

Heelp

Labels (1)
3 Replies
vikasmahajan

Create Variable   like vFecha use the same in set analysis see below post. 

https://community.qlik.com/t5/App-Development/Using-Variable-in-Filter-Pane-in-Qlik-Sense/td-p/16605...

 

Please make sure your date format  like 

Date(Date#([DateField], 'DD-MM-YYYY')) as Fecha vigencia hasta

hope this help

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.
Siercito
Partner - Contributor
Partner - Contributor
Author

Sorry, I think that I'm expressing bad.

As you can see in the first photo the filter pane shows me until 11-2022. I need to show only 45 days from today in the future and all te days before today since data was generated.

So the filter pane has to show from 01-01-2000 until 05-03-2022.

unknown.png

 

vikasmahajan

Try this:

Add this line in script

If( DateField>=(Today()-45) , 1, 0) AS Is45DayPeriod

 

in filter pane

=only({$<Is45DayPeriod={'1')}>}>} DateField)

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.