Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
Thank you Gary, this was a very good work around! Much appreciate the help!