topic Dynamic filter-pane updating in run time (possible?) in App Development

Dynamic filter-pane updating in run time (possible?)

hacr — Sat, 16 Nov 2024 01:57:09 GMT

Hi all

I was wondering if it's possible to genereate the filter values during runtime, based on the selection of a user.

The scenario includes at hierarchical filter - and I would like to hide the SUB-values, until the main group is selected. simplified like this:

Filter:

A
- AA
-- AAA
B
- BB
-- BBB
C
D

The Initial filter should then show A, B, C, D and pressing A would reveal -AA in the list.

Was looking into variables evaluating wether or not a value is selected, returning -1 or 0. Next step would be to filter the list, or maybe generate the list of values in a variable? But didn't succeed in passing a variable as input to a filter 🙂

Maybe it's not even possible, as the filter needs to reevaluate at every selection

Thanks in advance.

Re: Dynamic filter-pane updating in run time (possible?)

lironbaram — Wed, 08 Jul 2020 12:01:21 GMT

if you load your values to two separate fields :

parent and child

and you use those fields to build a drill down dimension in master items

then use this master item in a filter pane ,
when you'll select one parent automatically the filter pane will display the child field

Re: Dynamic filter-pane updating in run time (possible?)

hacr — Wed, 08 Jul 2020 13:07:32 GMT

Thank you for the reply. It would work if the other values should be hidden after selection, but I'm interested in having one list with the previous values as well.

Initial Filter:
A
B
C

Press the A and the filter is updated to:
A
-AA
B
C

I've partly solved it by using variables, defining my FIlter like;

=If(Match($(vFilter), 'A'), if(Filter LIKE '*--*',null(),Filter),if(Filter LIKE '*-*',null(),Filter))

I need to tune my variables, but the effect is working