I have a list box for grouping of user id's which falls under one category.
for that I have taken one list box and instead of field I have taken one expression and grouped the user id's using an if statement.
I have succeeded in that, but the problem is when I am selecting the value which is a list box the selection is reflecting through out the dashboard.But the value which I have selected is not getting highlighted in green color. what may be the possible reason?
Expression values cannot be selected. What happens instead is that values are selected in the fields you used in the expression. That's why the value in the listbox isn't highlighted.
I am not taking the fields as filters which I have used in the expression.
I have to group them under one category and when I select that group KPI should display the result for whole group.
in my scenario I have three groups to form so I am taking them individually in three list boxes. Previously I have taken two list boxes for two groups and I have succeeded in that case. now a new category came up and when I added that category also this issue came up.
for that I have taken one list box and instead of field I have taken one expression and grouped the user id's using an if statement.
You're using an expression instead of a single field. If you need that to behave like a field in a listbox then you should create such a field in the load script.
