topic Exclude field selection in QlikView

Exclude field selection

paulwalker — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

How to exclude field selection in Textbox, i have written in set analysis

like Sum({<Country=>}sales) this is working fine.....

But, i have used AGGR function in my expression, not working

Ex: Count(Aggr(Sum({<Country=>}sales), client)) this expression not working for exclude Country level.

is there anyway to exclude whole sheet ??

Thanks in Advance....

sunny_talwar — Mon, 06 Feb 2017 15:57:14 GMT

To exclude selection in all selections, you can try this

Sum({1} sales)

paulwalker — Mon, 06 Feb 2017 16:01:02 GMT

no, i want to exclude one field only

sunny_talwar — Mon, 06 Feb 2017 16:02:56 GMT

I guess try this:

Count({<Country=>} Aggr(Sum({<Country=>}sales), client))