Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
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
MVP & Luminary
MVP & Luminary

Re: Help in Expression

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


talk is cheap, supply exceeds demand
Not applicable

Re: Help in Expression

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