Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try a Chart of type Straight Table and for the expression use something like Sum([YourField])
Try a Chart of type Straight Table and for the expression use something like Sum([YourField])
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.
Thanks! QlikView Community rocks!
Thanks! You are the best!