Keep expression value

[#1]

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.

[tresesco]

You can use set analysis in the expression. Like:

=Sum({1}Amount)

{1} - ignores any selection in your app.

[vijetas42]

Hi,

Can elaborate little more what exactly you want to do?

[#4 · Accepted solution]

[#5 · Accepted solution]

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

[vijetas42]

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

[#7]

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

[vijetas42]

No, It works for all the list boxes