How to remove duplicates in my report or make my pivot table not count duplicates

[maudifer]

Hi all,

I have built a report in qlik view with a pivot table.

It is supposed to show the number of containers per vessel name and ETAs.

But the issue is the raw data i am pulling form my system is duplicating the containers

This is because the ETA is for each shipment, and there can be several shipments per containers

So as a result my qlik view pivot table is showing the number of shipments instead of the number of containers

is the a way i can use an expression in the script or table to tell the table to count only the number of containers and not record lines or shipments ?

See below a screen shot of the pivot table.

Can any one help me ?

[ajaysingh285]

Hi Maud , can u please provide the excel file too that helps me.

[isingh30]

There's no vessel column in the attached qvw? What is ETA - Expected time?

[wdchristensen · Accepted solution]

count(distinct containers)

[maudifer]

Hi Ajay

I trying to figure out how to attached an excel file in this reply

How can I attached any more documents or files ?

[maudifer]

Sorry i meant the Ship name instead of the vessel name

Yes, the ETA is the Estimated time of arrival

[maudifer]

Thanks so much it worked   I used as the expression in the pivot table.

And it is counting the container number, not the number of recors .

You made my day