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: 
Anonymous
Not applicable

Duplicate Count on the basis of select list of required field

Dear All,

Can anyone help me in getting the duplicate count on the basis of the select list of a field?

1) Used Straight Table

2) Dimension: =if(Match(CREATED_SYSTEM,'CLA','GOL','LOI','QUT','SEM','SITE-BULK'),CREATED_SYSTEM)

3 Expression: I want duplicate count only of above list        [ =Count(GID3)-Count(DISTINCT GID3)  ]-- Duplicate Count

For example

CLA---- Duplicate Count

Gol----- Duplicate Count

LOI-----Duplicate Count etc....

1 Solution

Accepted Solutions
swuehl
MVP
MVP

That's due to your calculated dimension.

Just enable option 'Suppress when value is NULL' on dimension tab.

View solution in original post

14 Replies
shanky1907
Creator II
Creator II

Please check the attached file. It should solve your query

Anonymous
Not applicable
Author

Thanks Shashank,

But i m not using licence version

can you mention the steps.

Thanks for reply

Anonymous
Not applicable
Author

Can any one Pls help me . in solving the above problem ?

qlikview979
Specialist
Specialist

Hi ,

LOAD AutoNumber(RowNo(),Person) as Rowno,Person,

     Sales

FROM

"https://community.qlik.com/message/1285146"

(html, codepage is 1252, embedded labels, table is @1);

Shashank used these expressiona



Use two dimensions like

Person

Rowno


and like


Untitled.png


Anonymous
Not applicable
Author

Thanks Mahesh,

But the same i wanted to do in Expression .

Still thanks for your input.

shanky1907
Creator II
Creator II

1.PNG2.PNG

Anonymous
Not applicable
Author

Thanks Shashank,

But I think you didn't get my question?

I want the system wise duplicate count.

For which I

1) Used Straight Table

2) Dimension: =if(Match(CREATED_SYSTEM,'CLA','GOL','LOI','QUT','SEM','SITE-BULK'),CREATED_SYSTEM)

Dimension       Expression

CLA

GOL

LOI

QUT

SEM

SITE-BULK

Now I duplicate Count expression wise.

Duplicate Count  = Count(GID3)-Count(DISTINCT GID3) 


If I used the above formula in Expression I got and extra dash with an unwanted total.

Dup Count.jpg

swuehl
MVP
MVP

That's due to your calculated dimension.

Just enable option 'Suppress when value is NULL' on dimension tab.

shanky1907
Creator II
Creator II

Please check 'Suppress when value is NULL' on dimension.