topic Re: Aggr() Function - Multiple Conditions in QlikView

Aggr() Function - Multiple Conditions

JacobLag — Sat, 16 Nov 2024 02:11:19 GMT

Hello everybody,

I want to create a new table using the aggr().

Simple example (in reality there are much more data)

How, do I create a table, which shows me only the Patients which have lived in Country A, but never in Country C?

First Step in order to get the patients who have lived in A:

Count(Aggr(Count({<Country={"A"}>} Patient), Patient))

Second Step to exclude Country B?

Do yuo have any ideas for me :)?

sunny_talwar — Fri, 18 Oct 2019 14:01:56 GMT

May be this

Count({<Patient = p({<Country = {'A'}>})-p({<Country = {'C'}>})>} Patient)

Count({<Patient = p({<Country = {'A'}>})*e({<Country = {'C'}>})>} Patient)

JacobLag — Mon, 21 Oct 2019 07:46:48 GMT

Thank you very much 🙂 it worked! I'm so happy