topic Re: Help in Expression in QlikView

Help in Expression

Wed, 25 Nov 2020 16:16:04 GMT

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

Thanks in advance

Gysbert_Wassenaar — Mon, 19 Dec 2016 11:19:46 GMT

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

Tue, 20 Dec 2016 05:43:22 GMT

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