topic Multiple category in App Development

Multiple category

Mahamed_Qlik — Thu, 01 Feb 2024 11:13:50 GMT

Dear all,

I have data as below :

We need to get

1) count of ID who comes under "USA & INDIA" both

( expected output as count is 2) and those ID are 101 and 104

2) count of ID who comes under only "INDIA"

( expected output as count is 1) and that ID are 105

hic — Thu, 01 Feb 2024 11:42:03 GMT

Count({<ID=P({<COUNTRY={USA}>} ID)*P({<COUNTRY={INDIA}>} ID)>} distinct ID)

Count({<ID=E({<COUNTRY= -{INDIA}>} ID)>} distinct ID)

Mahamed_Qlik — Mon, 19 Feb 2024 10:20:51 GMT

We have added new Month column and we want to group the above logic by month.

How can we achieve this or write aggr?

I tried as below but no luck :

AGGR(Count({<ID=P({<COUNTRY={USA}>} ID)*P({<COUNTRY={INDIA}>} ID)>} distinct ID),Month)

Mahamed_Qlik — Tue, 20 Feb 2024 04:01:36 GMT

Here is the data is currently displaying:
Expression :

COUNT({<CIVIL_ID=P({<BNFT_ID={'59'}>} CIVIL_ID)*P({<BNFT_ID={'56'}>} CIVIL_ID)>} distinct CIVIL_ID)

we want to display only highlighted records because those records are with type 56 & 59 and in same month only