Filter pane - Date Range Help

[Siercito]

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

[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

[Siercito]

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.

 

[vikasmahajan]

Try this:

Add this line in script

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

in filter pane

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

Vikas