topic Re: Set Analysis - filter on used fields in QlikView

Set Analysis - filter on used fields

twanqlik — Mon, 23 Apr 2018 16:29:27 GMT

I've noticed that when i filter on the fields that i used in my set analysis, the outcome of my set analysis doesn't change. It only changes when i filter on the fields that aren't used in my set analysis.

Hence, Sum({<FIELD= {1}>} CONSUMER_ID)

Filter on Field, e.g. value 0.

The outcome doesn't change.

However, when i filter on the Country, the outcome changes.

I was wondering how can i write my set analysis in such a way that i also can filter on the fields that i used in my set analysis?

Re: Set Analysis - filter on used fields

sunny_talwar — Mon, 23 Apr 2018 16:32:40 GMT

Try this

Sum({<FIELD *= {1}>} CONSUMER_ID)

Re: Set Analysis - filter on used fields

twanqlik — Mon, 23 Apr 2018 16:36:49 GMT

Thanks, that worked!

Re: Set Analysis - filter on used fields

sunny_talwar — Mon, 23 Apr 2018 16:40:30 GMT

read more about it here
Implicit Set Operators