topic Re: Qlik Sense Filter Pane in App Development

Qlik Sense Filter Pane

Trevor — Mon, 20 Dec 2021 21:05:46 GMT

Hi there,

I would like to please have a filter pane that presents a list of years, which once the user selects the year, the filter pane selects all years less than equal to the year selected.

For example, years 2010 to 2021 are presented in the filter pane, once the user selects 2017, all years 2010 to 2017 appear as being selected. So I guess something similar to typing <=2017 in the search box of the filter pane.

Is this possible?

Re: Qlik Sense Filter Pane

GaryGiles — Thu, 18 Feb 2021 23:32:58 GMT

@Trevor

I don't think you can get that kind of functionality in the Filter Pane.

An alternative would be to add a button (chart) and as the Action, choose 'Select values in a field'. Select your year field, for example, FiscalYear.

Then for the value use: =Concat({$<FiscalYear={"<=$(=max(FiscalYear))"}>} FiscalYear,';')

Once a year is selected, pressing the button will cause all years below the maximum currently select year(s) to be selected.

If no years are selected and the button is press, all years will be selected. You could work around that with an if(getselectedcount(FiscalYear) . . . logic.

It's not exactly what you were asking for, but it's probably the closest thing with Qlik out of the box.

Re: Qlik Sense Filter Pane

Trevor — Fri, 19 Feb 2021 03:49:02 GMT

Thank you Gary, this was a very good work around! Much appreciate the help!