topic Re: Count Set Analysis error in QlikView

Count Set Analysis error

didierodayo — Wed, 25 Nov 2020 16:16:04 GMT

I need some help working out what is wrong with this expression: I am getting error in expression.

I am trying to Count the contact numbers that appear more than once on the contact field in the same table.

count({<count(distinct[MOBILE_PHONE_NB]){'>1'}>}[MOBILE_PHONE_NB])

Re: Count Set Analysis error

Anonymous — Tue, 10 May 2016 23:13:49 GMT

Hi Didier,

Could you please provide more details about how do you want to display the data?

Regards,

-- Karla

Re: Count Set Analysis error

swuehl — Tue, 10 May 2016 23:18:46 GMT

The set expression syntax is not correct.

Have a look at

A Primer on Set Analysis

and try maybe something like

=Count({<[MOBILE_PHONE_NB] = {"=Count([MOBILE_PHONE_NB])>1"}>} DISTINCT [MOBILE_PHONE_NB])

Re: Count Set Analysis error

trdandamudi — Tue, 10 May 2016 23:28:34 GMT

Attached is a sample app and hope this helps you...

Re: Count Set Analysis error

didierodayo — Tue, 10 May 2016 23:42:41 GMT

hi all,

as you can see from this table I suspect there is some fraudulent activity.

- student 1 and student 11 are using the same phone number

- student 5 and 10 have similar number (the first 7 digits are the same)

I need the set analysis script to Identify similar(the first 7 digits are the same) or same numbers where the claimant_id is different. and return the phone number (s).

I hope this clarifies. Thanks a lot

Claimant_ID	CLAIM_ID	MOBILE_PHONE_NB
1	255	99784561
2	266	77542168
3	267	68542879
4	268	11789562
5	269	99784573
6	270	33535565
7	271	74145428
8	272	94852630
9	273	25893754
10	274	99784562
11	275	99784561

Re: Count Set Analysis error

didierodayo — Tue, 10 May 2016 23:45:59 GMT

Hi Thirumala,

I can't see your attachement. I have added a new documents to clarify what I need. could you resend the attachment please.

Thanks

Re: Count Set Analysis error

trdandamudi — Wed, 11 May 2016 14:01:47 GMT

I modified according to your logic and this will list out where the phone numbers are same:

Re: Count Set Analysis error

didierodayo — Wed, 11 May 2016 18:37:17 GMT

Hi Thirumala,

Where is your attachment? If you are having issues attaching maybe email it to me esterdid@hotmail.com

Thannks

Re: Count Set Analysis error

trdandamudi — Wed, 11 May 2016 18:52:39 GMT

I am not sure why you are not able to see the attachment... I do not have access to send emails..Any have here are the steps and hope this will be helpful......

Below is script:

Table:

Load * Inline [

Claimant_ID,CLAIM_ID,MOBILE_PHONE_NB

1, 255, 99784561

2, 266, 77542168

3, 267, 68542879

4, 268, 11789562

5, 269, 99784573

6, 270, 33535565

7, 271, 74145428

8, 272, 94852630

9, 273, 25893754

10, 274, 99784562

11, 275, 99784561

];

Now Create a Pivot Chart as below:

Dimensions:

Claimant_ID

MOBILE_PHONE_NB

Expressions:

=count({$<MOBILE_PHONE_NB={"=Count(MOBILE_PHONE_NB)>1"}>}Claimant_ID)