topic Filter pane - Date Range Help in App Development

Filter pane - Date Range Help

Siercito — Wed, 19 Jan 2022 13:27:04 GMT

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

Re: Filter pane - Date Range Help

vikasmahajan — Wed, 19 Jan 2022 13:54:59 GMT

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/1660532

Please make sure your date format like

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

hope this help

Vikas

Re: Filter pane - Date Range Help

Siercito — Wed, 19 Jan 2022 14:14:55 GMT

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.

Re: Filter pane - Date Range Help

vikasmahajan — Wed, 19 Jan 2022 14:22:15 GMT

Try this:

Add this line in script

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

in filter pane

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

Vikas