QLIKVIEW Duplicate data across multiple fields.

[Mark401sd]

Hi all,

I have source data which has multiple fields with duplicate data. I am having trouble creating an expression to remove duplicates across multiple fields.

Example of data:

SERIAL NUMBER   |   OPERATION   |   DEFECT CODE        |      DEFECT LOCATION

123                                SMT                   TOMBSTONE                  U1

123                                SMT                   SOLDER BRDGE            C25

123                                XRAY                 TOMBSTONE                  U1

123                                XRAY                 SOLDER BRDGE            C25

234                                SMT                   TOMBSTONE                  U5

234                                SMT                   SOLDER BRDGE            C28

234                                XRAY                 TOMBSTONE                  U5

234                                XRAY                 SOLDER BRDGE            C28

What I am trying to figure out is this.

If the Serial Number, Defect Code & Defect Location match then the qty is 1, regardless of the operations they are recorded against.

Expected Results -

Serial #        |       Defect Code            |     Defect Location        |     Qty

123                       Tombstone                            U1                                1

123                       Solder Bridge                       C25                              1          

234                      Tombstone                           U5                              1

234                     Solder Bridge                          C28                            1

I hope this makes sense; I am a novice so any help will be appreciated.

[Vegar · Accepted solution]

Could this expression be what you  are looking for?

Count (distinct [Serial Number] & [Defect Code] & [Defect Location])

[Mark401sd]

Yes, that worked. Appreciate your help, Thank you!