topic Re: Exclude Filter in QlikView

Exclude Filter

paulwalker — Fri, 15 Nov 2024 23:34:17 GMT

HI Community,

Facing issue with exclude selection, problem is same field using in aggregation.

I have to exclude CO selection, but if i give CO= not working - because same field in Aggregation.

Can you please help me..

NUM(AVG(AGGR((AVG({< GENDER={'M'}>}SALARY)-AVG({< GENDER={'F'}>}SALARY))
/
AVG({< GENDER={'M'}>}SALARY), CO, MUPC_CODE)),'##.#%')

Please note this expression using in textbox.

Thanks in Advance!!

Re: Exclude Filter

tresB — Wed, 25 Nov 2020 08:51:59 GMT

@paulwalker

You can try putting the set component in aggr() and outer avg() as well like:

NUM(AVG( {<CO>} AGGR( {<CO>}(AVG(..

Re: Exclude Filter

MayilVahanan — Wed, 25 Nov 2020 08:54:03 GMT

Hi @paulwalker

Try like below

NUM(AVG({<CO=>}AGGR((AVG({< GENDER={'M'},CO=>}SALARY)-AVG({< GENDER={'F'},CO=>}SALARY))
/
AVG({< GENDER={'M'},CO=>}SALARY), CO, MUPC_CODE)),'##.#%')