- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- load data
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try a Chart of type Straight Table and for the expression use something like Sum([YourField])
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try a Chart of type Straight Table and for the expression use something like Sum([YourField])
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks! QlikView Community rocks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks! You are the best!