topic Re: Keep expression value in QlikView

Keep expression value

Wed, 30 Apr 2014 04:16:50 GMT

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.

Re: Keep expression value

tresB — Wed, 30 Apr 2014 04:33:55 GMT

You can use set analysis in the expression. Like:

=Sum({1}Amount)

{1} - ignores any selection in your app.

Re: Keep expression value

vijetas42 — Wed, 30 Apr 2014 04:35:19 GMT

Hi,

Can elaborate little more what exactly you want to do?

Re: Keep expression value

Wed, 30 Apr 2014 05:09:48 GMT

Re: Keep expression value

Wed, 30 Apr 2014 05:13:30 GMT

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

Re: Keep expression value

vijetas42 — Wed, 30 Apr 2014 05:52:26 GMT

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

Re: Keep expression value

Wed, 30 Apr 2014 06:20:29 GMT

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

Re: Keep expression value

vijetas42 — Wed, 30 Apr 2014 06:26:42 GMT

No, It works for all the list boxes