Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
shadow99
New Contributor III

duplicate records

HI guys,

I created a report where A,B,C are cities and e and f are the distance between them respectively.i am getting the report but some of the records are duplicate where the distance in the first line shows correct but the second line is the duplicate record with the distance showing as "-" null.

what could be the possible problem?

City1           City2           City3            Distance 1       Distance2

A                 B                     C            10                      25

A                 B                    C             10                       -

B                C                    D              10                     100

The above shows my report I dont want the same record now i can check the supress null values here but there are few records where the cities are not present so even those records will be supress I do not want that.