How to filter values in List box based on the value in variable ?

[shekhar_analyti]

Hi All ,

How to filter values in List box based on the value in variable ?

In the attached app based on the season i want the match ids to be filtered in List box .
Example - if user selects season 1 then in list box , only the match id of season 1 should be shown .

Thanks & Regards

Shekar

[senpradip007]

There is no app is attached. Please attached the same.

[shekhar_analyti]

Sorry For missing that ..

Please find attached

[senpradip007]

Have a look at this.

[antoniotiman · Accepted solution]

Hi,

try this in List Box

=Aggr(Only({<match_id=P({<season={'$(vSelect_Season)'}>})>} match_id),match_id)

Regards,

Antonio

[shekhar_analyti]

Thanks Antonio , this is exactly what was required

[kusumanchir]

Hi Shekhar,

Please find the attached app.

I just edited the expression in the list box with '=match_id'. And also checked the 'Hide Excluded' option.

[shekhar_analyti]

But on selecting any value in the list box having expression

(Aggr(Only({<match_id=P({<season={'$(vSelect_Season)'}>})>} match_id),match_id)) , makes other values to disappear .

Cant we keep other values intact , even on selection ?

[antoniotiman]

i'm afraid not, This is behavior of Aggr() function.

[shekhar_analyti]

stalwar1‌ ... any workaround ?