Show Duplicates of Dimension in straight table

[Thabang231]

Hi Qlik champs,

I need help here, I am trying to show the duplicate value of the dimension when the measure that is calculating returns 1 to show that it is duplicate row and has a zero of the same duplicate. and when i uncheck include zero values in add-ons the table show the rows that pulls 1 only. please see the photo attached.

The Code Field as a dimension if it has duplicates it should show those 2 records the 1 and zero, if the Code only has zero as Number it should not display.

here is the calculation of the measure named 'Number' : 

COUNT(IF(AGGR(COUNT({<duplicates = {'Duplicates'}>}[Number]),[Number])>1,1))

Your help is highly appreciated.

Regards

[JandreKillianRIC]

Hi @Thabang231 

I think the way you calculate the Duplicates field is incorrect. And you might need another field to avoid Qlik from "consolidating" the data in the table. This is what I would do... 

Here is my table 

my result 

Just build a table with 2 dimensions. Number and ID. Below is the script. 

Temp:
Load * Inline [
Number,Value
1,83
1,84
2,86
2,75
3,88
3,65
4,59
4,85
5,73
6,58
7,87
10,61
10,99
];


Identify:
Load
	RowNo()-1 as ID
AutoGenerate(2); // This will create the 0 and 1 needed 

Join (Identify)
Duplicates:
Load 
	Number, 
    IF(Count(Number)>1, 'Duplicate', 'Normal') as Duplicate
Resident Temp
Group By Number; 

Regards Jandre