Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Shahzad_Ahsan
Contributor II

Show only duplicate values in table chart

Hi Everyone

I need to show only duplicate values in table chart.

My table is like this

IdName
101A
102A
103A
104B
105B
106C
107D
108E
109F
110G
111G
112H
113I

I need like this in table chart

IdName
101A
102A
103A
104B
105B
110G
111G
1 Solution

Accepted Solutions
MVP
MVP

Re: Show only duplicate values in table chart

try a straight table with

dimension

    Id

expression

    only({$ <Name={"=count(Name)>1"}>} Name)

4 Replies
MVP
MVP

Re: Show only duplicate values in table chart

try a straight table with

dimension

    Id

expression

    only({$ <Name={"=count(Name)>1"}>} Name)

Shahzad_Ahsan
Contributor II

Re: Show only duplicate values in table chart

Hi Massimo

This is what I needed

Thank you

Shahzad_Ahsan
Contributor II

Re: Show only duplicate values in table chart

Hi Massimo

I have one more question related to this.

Can we count number of duplicated rows as KPI , that means 7

Shahzad_Ahsan
Contributor II

Re: Show only duplicate values in table chart

Its ok

I got it

Count(Aggr( only({$ <Name={"=count(Name)>1"}>} Name),Id))

Community Browser