Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help in Expression

Hi All,

I  need  count of accounts with below conditions  in single expression .


1.For Abc Name:

If same account is covered in 2  Abc names then count is 2 . The count will be taken from  unique group by Meeting ID

2.other than  Abc Name

If  the same account is covered in 2 names other than  Abc names then count is 1 . The count will be taken from  unique group by Meeting ID

Note:Names with  prefixed with Abc called Abc Names

    

Meeting IDMeeting NameNameAccount ID
M01MMMAbc  phase1A001
M02AAAAbc phase2A002
M03DDDAbc Phase 3A001
M05EEEAbc phase 4A003
M06FFFAnoroA002
M07HHHAnoro1A003
M08JJJRelvarA003
M09FFFRelvar1A005

Thanks in advance

2 Replies
Gysbert_Wassenaar

Perhaps like this: Count(Distinct If(WildMatch(Name, 'Abc*'), Name, [Account ID]) )


talk is cheap, supply exceeds demand
Not applicable
Author

Hi ,

If the same account is covered in 2 names other than  Abc names then i should get count is 1 .

Currently count is coming for 2.

For  Abc names  count should be  2  if same account is covered in 2  Abc names .

The count will be taken from  unique group by Meeting ID