topic Re: Filtering values yet retaining original %s in QlikView

Filtering values yet retaining original %s

mattphillip — Mon, 08 Dec 2014 12:00:44 GMT

Hoping someone can help. I have a bar chart counting the five different numerical values (1-5) within a field. What I'd like to do, and so far have not managed to succeed in doing is to limit the visible fields (for example, values 1 and 2 only) but to retain their original % based on the complete set of five values not the revised total based on the two displayed values.

The expression I've tried is: =sum([SIMD Quint)/sum(TOTAL [SIMD Quint]) with the relative option selected.

Is this achievable?

Any help would be much appreciated.

Matt

Re: Filtering values yet retaining original %s

tresB — Mon, 08 Dec 2014 12:04:27 GMT

Not sure if got your point right. Maybe you can try something like:

=sum({< [SIMD Quint]={1,2}>}[SIMD Quint])/sum(TOTAL [SIMD Quint])

Re: Filtering values yet retaining original %s

Mon, 08 Dec 2014 12:09:15 GMT

Hi Matt,

I think you want to use set analysis on the total section of your expression, so that each SIMD Quint is calculating from the field total. Try the below

sum([SIMD Quint])/sum({<[SIMD Quint]=>}TOTAL [SIMD Quint])

hope that helps

Joe

Re: Filtering values yet retaining original %s

mattphillip — Mon, 08 Dec 2014 13:26:13 GMT

Thanks guys! I tried both and it almost worked. When I combined both it worked fully.

sum({< [SIMD Quint]={1,2}>}[SIMD Quint])/sum({<[SIMD Quint]=>}TOTAL [SIMD Quint])

Many thanks!

Re: Filtering values yet retaining original %s

Mon, 08 Dec 2014 13:43:53 GMT

Hi Matt,

ah I thought the 1&2 was just an example of what you might select down to, not the specific limit you wanted, glad that's working for you now