Multiple filter or using multiple conditions

[#1]

Hello Experts

I have done lot of research in the QlikView community to find the solution but didn't find correct solution....Can somebody help me on this....this is little urgent need to find a logic.

I have a list of UserName (Field) aligned to ID(Field) but the UserNames are duplicated and ID are Unique say for example:

UserName      ID

ABC                1

DBC                2

ARP                3

ABC                4

DBC                5

ARP                6

But I need to find a count or getcount of Distinct users

Example: 1 - If ABC is considered in ID (1) then he should not be considered in ID (4)

Example: 2 - If DBC is considered in ID (2) then he should not be considered in ID (5)

(1) I tried with this formula        =Count(UserName = {<ID={'1'}>})      But it's now working

(2) =Count(Distinct UserName = {<ID={'2'}>} =-  {{<ID={'5'}>}})

          Even this didn't work.

(3) Count([UserName] OnlyIf {<ID={'2'},>})   This also didnt work

Thanks a lot in advance

[#2]

Hi Mahesh,

Thanks for your response in the first place.

However, the ID (6), UserName (ARP) and Count(UserName) should be (0).

Because ARP we have already considered in ID (3), hope i am clear.

ID,UserName, Count(UserName)

1         ,ABC,                     1

2         ,DBC,                     1

3         ,ARP,                      1

6         ,ARP,                      0

Kindly, let me know how to get the output

Thank You,

Vinay