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: 
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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

4 Replies
Anonymous
Not applicable
Author

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

swuehl
MVP
MVP

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
Author

Thanks! QlikView Community rocks!

Not applicable
Author

Thanks! You are the best!