Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Count all the duplicates

Hello Community,

I manage a dashboard that upload everyday the workflow of a TE dept.

Each day hundreds of trip numbers are uploaded and processed.

Sometimes there are not processed the same day, so they will reappear on the next workflow load the day after.

Sometimes, some trip numbers reappear after a few weeks because they have been processed but rejected and therefore submitted again.

Here is what I would like to do:

- Track all the duplicates trip number not processed yet : those have a unique code and the same posting date.

- Track all the duplicates trip number rejected : those have a unique code and therefore a different posting date.

I just need to get the sum of those 2 kind of duplicates, I dont need more details.

Under excel I guess I would have simply used a "SumProduct" formula but I dont know how to do so under QlikView.

Thank you for your help 

Tags (2)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Count all the duplicates

See attached qvw


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Re: Count all the duplicates

See attached qvw


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Not applicable

Re: Count all the duplicates

Thank you Gysbert

This works perfectly