How to show Duplicates and non duplicate ids in qlik dashboard

[Lucky1]

Hi Team,

I have duplicates in my id field.like below

ID 

1

2

1

3

1

When i add ID field into sample table I should get same as above

ID 

1

2

1

3

1

but I am getting ID

1

2

3

it is deleting duplicate ids. I have tried rowno function it is working but my client doesnt want rownum field in the dashboard. How can i achieve this to get all ID's in the dashboard table

[Mark_Little · Accepted solution]

HI,

This is how Qlik has always work with the associative modeling. ID would normally be a unique value and will show as mentioned above until a field is added that makes  unique. I.e.. if it was customer ID something like contact date where there is multiple will then break it out. 

[kkarlste]

Hi

This is the initial situation choose table box and I want table box only bigger than 2018

And box show this