topic Compare with Attribute on same field in QlikView

Compare with Attribute on same field

paulwalker — Fri, 15 Nov 2024 23:32:15 GMT

Hi Community,

Facing issue with expression, I have similar data like below

If it is same CODE for EMP (N and Y), they have to calculate sum(SALARY)

trying below expression, but not working..

=IF(AGGR(ONLY({<EMP={'N'}>}CODE), CODE) = AGGR(ONLY({<EMP={'Y'}>}CODE), CODE), SUM(SALARY))

Output:

Thanks in advance

agigliotti — Tue, 01 Dec 2020 15:48:55 GMT

You could try with the below expression:
=Sum( if( count( distinct EMP ) = 2, SALARY ) )

with CODE as dimension.

I hope it can helps.

Best Regards

Andrea

edwin — Tue, 01 Dec 2020 23:15:30 GMT

try this:
=sum({<CODE=p({<EMP={'Y'}>}CODE)>}SALARY)

which means if there exists a CODE where EMP=Y, sum it

marcus_sommer — Wed, 02 Dec 2020 14:48:56 GMT

Another one:

SUM({<EMP={'N'}> * <EMP={'Y'}>} SALARY)

- Marcus