Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
maudifer
Contributor III
Contributor III

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

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 ?

Capture Qlik PMK.JPG

1 Solution

Accepted Solutions
wdchristensen
Specialist
Specialist

count(distinct containers)

View solution in original post

6 Replies
ajaysingh285
Contributor III
Contributor III

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

isingh30
Specialist
Specialist

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

wdchristensen
Specialist
Specialist

count(distinct containers)

maudifer
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

Sorry i meant the Ship name instead of the vessel name

Yes, the ETA is the Estimated time of arrival

maudifer
Contributor III
Contributor III
Author

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