Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
try this in List Box
=Aggr(Only({<match_id=P({<season={'$(vSelect_Season)'}>})>} match_id),match_id)
Regards,
Antonio
There is no app is attached. Please attached the same.
Sorry For missing that ..
Please find attached
Have a look at this.
Hi,
try this in List Box
=Aggr(Only({<match_id=P({<season={'$(vSelect_Season)'}>})>} match_id),match_id)
Regards,
Antonio
Thanks Antonio , this is exactly what was required
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.
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 ?
i'm afraid not, This is behavior of Aggr() function.
stalwar1 ... any workaround ?