Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Remove Duplicates

Dear All,

I Want to remove Duplicates Values from somes Calls in my Application. Here ist the Description:

 

Description:

 

  1. Duplicates must be removed only for Automatic and Manual (not for Info)
  2. Automatic is counted as not a duplicate in case an Info Call happened before
  3. Automatic is acknowledged as Duplicate if:
    - there is less than one hour to the previous Automatic for the same VIN
    - there is no info call between the automatic and the previous automatic for the same VIN
  4. Manual is acknowledged as Duplicate if:
    - there is less than one hour to the previous Manual for the same VIN

  

Here are some examples

 

Info Mo 00:40

Automatic Mo 00:41

Automatic Mo 00:45

Info Mo 01:05

Automatic Mo 01:10

1

1

0

1

1

Total:

Info

2

Automat

2

 

 

Info Sa 23:50

Automatic Sa 23:52

Automatic Mo 00:05

1

1

1

Total:

Info:

1

Automat:

2

 

 

Info Mo 00:40

Automatic Mo 00:41

Automatic Mo 01:42

1

1

1

Total:

Info:

1

Automat:

2

 

 

Manual Mo 00:40

Manual Mo 00:41

Manual Mo 01:42

1

0

1

Total:

Manual:

2

 

Can someone help me please?

Regards,

William

 

1 Reply
MarcoWedel