Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a list which contains names and values as expression. the values represents the count of record for each name. example
Banks 155
Education 255
Gov 30
...
I also have other objects like charts etc...
When choosing one of the names in the list, it filter the table based on the selected in the list, All other names in the list will have value count of 0 as a result of filtering.
Banks 155
Education 0
Gov 0
The question is, How I can keep the values even after the selection.
As you see in the images bellow.
The first list has no filter, so it shows all names with all values (count).
the second one has on of the option is selected which filter the data, In this case all other values (count) becomes 0. I want to keep the these values when filter is applies
You can use set analysis in the expression. Like:
=Sum({1}Amount)
{1} - ignores any selection in your app.
Hi,
Can elaborate little more what exactly you want to do?
As you see in the images bellow.
The first list has no filter, so it shows all names with all values (count).
the second one has on of the option is selected which filter the data, In this case all other values (count) becomes 0. I want to keep the these values when filter is applies
Hi,
Try to add expression in list box expression where you have added count(Values) instead of that put =count({1}Values)
hope this will help you
Thanx it works, but still have a problem
I want the values to changes if filtering anther field.
suppose I have 2 list-box,
when choosing from List 1, all values in List 2 will be filtered based on the selection of List 1, but the List 1 values will remain. the same when choosing from list 2
No, It works for all the list boxes