topic Re: restricted condition in sum function in QlikView

restricted condition in sum function

Tue, 21 Mar 2017 17:36:17 GMT

Hi all,

I have a question regarding the use of condition in sum function. I have the expression as follows at the moment.

count( {<Country-={'Local'}, B= {1}, C -= {'text'}>}user)

However, the number always changed, when I selected some country. What I want is to deactivate the selection of country.

I know the use of 1 to be inserted to the expression like count( {1<Country-={'Local'}, B= {1}, C -= {'text'}>}user), but then no matter whether I select a additional field D. The number does not change as well.

Does anyone know how to solve this solution? Thank you

Re: restricted condition in sum function

sunny_talwar — Tue, 21 Mar 2017 18:22:19 GMT

Reposition the negative sign from front of the = to back of the =

Count({<Country = -{'Local'}, B = {1}, C -= {'text'}>}user)

or try this

Count({<Country = e({<Country = {'Local'}>}), B = {1}, C -= {'text'}>}user)

Re: restricted condition in sum function

Wed, 22 Mar 2017 10:33:47 GMT

Thanks! it works!