Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

Highlight Duplicates

In my project i have a field which has alphanumeric characters which are entered manually at backend database, when i show up that field in my dashboard under straight table i can see all the values, now my question is i want to highlight the duplicate entries may i know what is the expression or script to be used

8 Replies

Re: Highlight Duplicates

Can you give an example?

You should not have duplicates in your table/filed.

Not applicable

Re: Highlight Duplicates

We have client working on different projects and they need to provide different ids for different project but they use same ids for 3 to 4 projects sometimes and we need to find it, example is below

 

GB1-DBN01.02.02.22
GB1-DBN01.02.02.20
GB1-AVI03.55.01.98.35
NL1-AH003.05.01.08, .07,
US1-AHDMR.05.01.03, NL1-
GB1-AVI06.01.01.07
GB1-DBN01.02.02.07; DE1-
SG1-DBN01.02.01.11
SG1-DBN01.02.01.17
GB1-DBN01.02.01.53; DE1-
GB1-TNT01.03.01.15
US1-DBN01.02.02.22; US1-
US1-NSS05.10.05.10
US1-FSERV.10.05.30
US1-FSERV.10.10.10
US1-FSERV.10.05.20
FI1-NKM01.04.03.06
FI1-NKM01.04.03.05
FI1-NKM01.04.07.05
FI1-NKM01.05.02.09
FI1-NKM01.05.07.03
GB1-TNT01.03.01.15
NL1-PLTTT.01.01.02
GB1-AVI05.01.01.48
Not applicable

Re: Highlight Duplicates

Hi Pratheek

U can use the following expression as a listbox dimension.  The listbox can then be use to filter the straight table to only show the duplicate values

=if(aggr(count(field),field) > 1, field)

Re: Highlight Duplicates

Which of those are duplicates?

Not applicable

Re: Highlight Duplicates

for examples they have entered the same numbers for all projects

 

CA1-GOMT1.01.01.05
CA1-GOMT1.01.01.05
CA1-GOMT1.01.01.05
CA1-GOMT1.01.01.05
CA1-GOMT1.01.01.05
CA1-GOMT1.01.01.05
CA1-GOMT1.01.01.05
Not applicable

Re: Highlight Duplicates

Hi Pratheek

You can use the following expression in the background window in the expression window as well as the dimension window:

=if(aggr(count(field),field) > 1, LightGreen())

screenshot.png

Not applicable

Re: Highlight Duplicates

Hi Chris

Thank you for your response but it is not working

Not applicable

Re: Highlight Duplicates

Ji Pratheek

I've attached my model so that you can view my example

Community Browser