topic Re: Why do i get repeating rows? in QlikView https://community.qlik.com/t5/QlikView/Why-do-i-get-repeating-rows/m-p/837855#M294586 <HTML><HEAD></HEAD><BODY><P>You can try concatenating both the tables into 1. </P><P></P><P>Also test in a Table box with all the required fields, to study what is making it duplicate.</P></BODY></HTML> Tue, 12 May 2015 05:06:14 GMT 2015-05-12T05:06:14Z Why do i get repeating rows? https://community.qlik.com/t5/QlikView/Why-do-i-get-repeating-rows/m-p/837852#M294583 <HTML><HEAD></HEAD><BODY><P>I know that I have not done this correctly, but i am unsure how to fix it.&nbsp; The data is fine it is the display that is now working ....</P><P>jo</P><P></P><P></P><P><IMG __jive_id="86222" alt="untitled.GIF" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/86222_untitled.GIF" style="width: 620px; height: 70px;" /></P><P></P><P>this is how I have linked the tables:</P><P><IMG __jive_id="86221" alt="untitled2.GIF" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/86221_untitled2.GIF" style="height: auto;" /></P><P></P><P>so what I find now is that if I make the BP Mazda/AP Mazda/BP Ford /AP Ford as calculated columns coming in from Excel it is different to doing the calculation as an expression in the pivot table. </P><P><IMG alt="untitled.GIF" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/86372_untitled.GIF" style="width: 620px; height: 345px;" /></P><P>So ... do not need comment 3 (more to come ...)</P></BODY></HTML> Tue, 12 May 2015 04:24:41 GMT https://community.qlik.com/t5/QlikView/Why-do-i-get-repeating-rows/m-p/837852#M294583 josephinetedesc 2015-05-12T04:24:41Z Re: Why do i get repeating rows? https://community.qlik.com/t5/QlikView/Why-do-i-get-repeating-rows/m-p/837853#M294584 <HTML><HEAD></HEAD><BODY><P>It looks like you should try to show the Comment1-3 as expressions instead of dimensions.</P></BODY></HTML> Tue, 12 May 2015 04:28:58 GMT https://community.qlik.com/t5/QlikView/Why-do-i-get-repeating-rows/m-p/837853#M294584 danieloberbilli 2015-05-12T04:28:58Z Re: Why do i get repeating rows? https://community.qlik.com/t5/QlikView/Why-do-i-get-repeating-rows/m-p/837854#M294585 <HTML><HEAD></HEAD><BODY><P>The comments depend on the location (not on the date), thats why you get different values per location but not per month and year. </P></BODY></HTML> Tue, 12 May 2015 05:05:53 GMT https://community.qlik.com/t5/QlikView/Why-do-i-get-repeating-rows/m-p/837854#M294585 danieloberbilli 2015-05-12T05:05:53Z Re: Why do i get repeating rows? https://community.qlik.com/t5/QlikView/Why-do-i-get-repeating-rows/m-p/837855#M294586 <HTML><HEAD></HEAD><BODY><P>You can try concatenating both the tables into 1. </P><P></P><P>Also test in a Table box with all the required fields, to study what is making it duplicate.</P></BODY></HTML> Tue, 12 May 2015 05:06:14 GMT https://community.qlik.com/t5/QlikView/Why-do-i-get-repeating-rows/m-p/837855#M294586 2015-05-12T05:06:14Z Re: Why do i get repeating rows? https://community.qlik.com/t5/QlikView/Why-do-i-get-repeating-rows/m-p/837856#M294587 <HTML><HEAD></HEAD><BODY><P>Yes i have cut down my table - and the pivot table is not working correctly although the straight table does.</P><P><BR /> </P></BODY></HTML> Tue, 12 May 2015 22:58:06 GMT https://community.qlik.com/t5/QlikView/Why-do-i-get-repeating-rows/m-p/837856#M294587 josephinetedesc 2015-05-12T22:58:06Z