topic How QlikView handles duplicated records? in QlikView https://community.qlik.com/t5/QlikView/How-QlikView-handles-duplicated-records/m-p/955259#M328340 <HTML><HEAD></HEAD><BODY><P>Dear Expert,</P><P></P><P>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?</P><P></P><P>Any suggestion is greatly appreciated!</P><P></P><P>Weidong</P></BODY></HTML> Fri, 06 Nov 2015 20:12:45 GMT 2015-11-06T20:12:45Z How QlikView handles duplicated records? https://community.qlik.com/t5/QlikView/How-QlikView-handles-duplicated-records/m-p/955259#M328340 <HTML><HEAD></HEAD><BODY><P>Dear Expert,</P><P></P><P>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?</P><P></P><P>Any suggestion is greatly appreciated!</P><P></P><P>Weidong</P></BODY></HTML> Fri, 06 Nov 2015 20:12:45 GMT https://community.qlik.com/t5/QlikView/How-QlikView-handles-duplicated-records/m-p/955259#M328340 2015-11-06T20:12:45Z Re: How QlikView handles duplicated records? https://community.qlik.com/t5/QlikView/How-QlikView-handles-duplicated-records/m-p/955260#M328341 <HTML><HEAD></HEAD><BODY><P>Try a Chart of type Straight Table and for the expression use something like <EM>Sum([YourField])</EM></P></BODY></HTML> Fri, 06 Nov 2015 20:18:54 GMT https://community.qlik.com/t5/QlikView/How-QlikView-handles-duplicated-records/m-p/955260#M328341 Anonymous 2015-11-06T20:18:54Z Re: How QlikView handles duplicated records? https://community.qlik.com/t5/QlikView/How-QlikView-handles-duplicated-records/m-p/955261#M328342 <HTML><HEAD></HEAD><BODY><P>Right, a table box only shows unique combinations of the field values.</P><P></P><P>If you want to aggregate values, use a straight table chart with dimensions and aggregation functions in expressions.</P><P></P><P>You can also aggregate in the script by using GROUP BY clause and aggregation functions.</P></BODY></HTML> Fri, 06 Nov 2015 20:19:24 GMT https://community.qlik.com/t5/QlikView/How-QlikView-handles-duplicated-records/m-p/955261#M328342 swuehl 2015-11-06T20:19:24Z Re: How QlikView handles duplicated records? https://community.qlik.com/t5/QlikView/How-QlikView-handles-duplicated-records/m-p/955262#M328343 <HTML><HEAD></HEAD><BODY><P>Thanks! QlikView Community rocks!</P></BODY></HTML> Fri, 06 Nov 2015 20:29:34 GMT https://community.qlik.com/t5/QlikView/How-QlikView-handles-duplicated-records/m-p/955262#M328343 2015-11-06T20:29:34Z Re: How QlikView handles duplicated records? https://community.qlik.com/t5/QlikView/How-QlikView-handles-duplicated-records/m-p/955263#M328344 <HTML><HEAD></HEAD><BODY><P>Thanks! You are the best!</P></BODY></HTML> Fri, 06 Nov 2015 20:30:35 GMT https://community.qlik.com/t5/QlikView/How-QlikView-handles-duplicated-records/m-p/955263#M328344 2015-11-06T20:30:35Z