topic Re: How to show Duplicated rows? in QlikView

How to show Duplicated rows?

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hello there,

I'm using SAP as the Database, and I link it to mu Qlikview. And I have some duplicated rows in SAP which are shown in Qlikview.

My question here is how to show them? to get an accurate result.

I heard there is a function I add and it does the job, but found nothing helpful on the internet.

Much appreciated,

jmvilaplanap — Mon, 21 May 2018 15:42:33 GMT

Hi,

You can create a field with RowNo() or RecNo() when you load the data

Regards

Anonymous — Tue, 22 May 2018 11:03:28 GMT

Hello,

Thanks for responding. I believe this is not what I'm looking for, let me explain more.

There is a record in SAP that I can't see in QlikView because it is duplicated. I want to see the duplicated result in QlikView.

Much appreciated

ogautier62 — Tue, 22 May 2018 11:29:33 GMT

Hi,

first when you load your data add a field such autonumber (to have a key) named ID

then in a sheet

in dimension put your functionnal key where you have duplicated

and in expression if(count (distinct ID) > 1 , "what you want",)

then you'll have only duplicated with their ID

regards