How to show Duplicated rows?

[Anonymous]

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,

J

[jmvilaplanap]

Hi,

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

Regards

[Anonymous]

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]

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