Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

How QlikView handles duplicated records?

Dear Expert,

I came across a situation that I have a file with duplicated records. When I loaded it into QlikView, it is in the table preview however when I create table box to display the table contents QlikView only display the unique lines. It supposed to sum the duplicated lines. How can I do that?

Any suggestion is greatly appreciated!

Weidong

Tags (1)
1 Solution

Accepted Solutions

Re: How QlikView handles duplicated records?

Try a Chart of type Straight Table and for the expression use something like Sum([YourField])

View solution in original post

4 Replies

Re: How QlikView handles duplicated records?

Try a Chart of type Straight Table and for the expression use something like Sum([YourField])

View solution in original post

MVP
MVP

Re: How QlikView handles duplicated records?

Right, a table box only shows unique combinations of the field values.

If you want to aggregate values, use a straight table chart with dimensions and aggregation functions in expressions.

You can also aggregate in the script by using GROUP BY clause and aggregation functions.

Not applicable

Re: How QlikView handles duplicated records?

Thanks! QlikView Community rocks!

Not applicable

Re: How QlikView handles duplicated records?

Thanks! You are the best!