topic Re: Pivot Doubles Values but Straight Table is Correct in QlikView https://community.qlik.com/t5/QlikView/Pivot-Doubles-Values-but-Straight-Table-is-Correct/m-p/1451157#M799286 <HTML><HEAD></HEAD><BODY><P>Please provide the screenshot of the table, dimensions used and measures?</P></BODY></HTML> Fri, 08 Dec 2017 16:11:31 GMT MK9885 2017-12-08T16:11:31Z Pivot Doubles Values but Straight Table is Correct https://community.qlik.com/t5/QlikView/Pivot-Doubles-Values-but-Straight-Table-is-Correct/m-p/1451155#M799284 <HTML><HEAD></HEAD><BODY><P>I'm creating a pivot table with amounts and counts but it doubles both values. If we use a straight table or a tablebox the amounts are correct but then I cannot get the layout I want. When I preview the table in tableviewer the amounts are correct. I have even made sure this table is in no way linked to any other table and I still receive double the values in the pivot. Do you have any suggestions or would you know what the cause of this is?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Pivot-Doubles-Values-but-Straight-Table-is-Correct/m-p/1451155#M799284 greend21 2020-11-25T16:16:04Z Re: Pivot Doubles Values but Straight Table is Correct https://community.qlik.com/t5/QlikView/Pivot-Doubles-Values-but-Straight-Table-is-Correct/m-p/1451156#M799285 <HTML><HEAD></HEAD><BODY><P>It would help if you included your expressions, but I suspect you have duplicate rows.</P></BODY></HTML> Fri, 08 Dec 2017 16:09:13 GMT https://community.qlik.com/t5/QlikView/Pivot-Doubles-Values-but-Straight-Table-is-Correct/m-p/1451156#M799285 m_woolf 2017-12-08T16:09:13Z Re: Pivot Doubles Values but Straight Table is Correct https://community.qlik.com/t5/QlikView/Pivot-Doubles-Values-but-Straight-Table-is-Correct/m-p/1451157#M799286 <HTML><HEAD></HEAD><BODY><P>Please provide the screenshot of the table, dimensions used and measures?</P></BODY></HTML> Fri, 08 Dec 2017 16:11:31 GMT https://community.qlik.com/t5/QlikView/Pivot-Doubles-Values-but-Straight-Table-is-Correct/m-p/1451157#M799286 MK9885 2017-12-08T16:11:31Z Re: Pivot Doubles Values but Straight Table is Correct https://community.qlik.com/t5/QlikView/Pivot-Doubles-Values-but-Straight-Table-is-Correct/m-p/1451158#M799289 <HTML><HEAD></HEAD><BODY><P>The expression is just sum(FieldA). Where would the duplicate row be? it doesnt show in table viewer&gt;preview or in the straight table. I also know the duplicate row does not exist in the actual data being loaded into Qlikview.</P></BODY></HTML> Fri, 08 Dec 2017 16:16:25 GMT https://community.qlik.com/t5/QlikView/Pivot-Doubles-Values-but-Straight-Table-is-Correct/m-p/1451158#M799289 greend21 2017-12-08T16:16:25Z Re: Pivot Doubles Values but Straight Table is Correct https://community.qlik.com/t5/QlikView/Pivot-Doubles-Values-but-Straight-Table-is-Correct/m-p/1451159#M799290 <HTML><HEAD></HEAD><BODY><P>I can't show the information. But basically it is going through a spreadsheet about bank information. It reads the deposit date on the left and then makes a table for the next few colums, day B-D. Then it loads through and gets the deposit date and makes a table for E-G. All these tables are concatenated. Each section only has one total amount field so each total is grabbed onced.</P></BODY></HTML> Fri, 08 Dec 2017 17:10:13 GMT https://community.qlik.com/t5/QlikView/Pivot-Doubles-Values-but-Straight-Table-is-Correct/m-p/1451159#M799290 greend21 2017-12-08T17:10:13Z Re: Pivot Doubles Values but Straight Table is Correct https://community.qlik.com/t5/QlikView/Pivot-Doubles-Values-but-Straight-Table-is-Correct/m-p/1451160#M799292 <HTML><HEAD></HEAD><BODY><P>Can you scramble the sensitive fields and then post a sample qvw?</P></BODY></HTML> Fri, 08 Dec 2017 20:01:26 GMT https://community.qlik.com/t5/QlikView/Pivot-Doubles-Values-but-Straight-Table-is-Correct/m-p/1451160#M799292 m_woolf 2017-12-08T20:01:26Z Re: Pivot Doubles Values but Straight Table is Correct https://community.qlik.com/t5/QlikView/Pivot-Doubles-Values-but-Straight-Table-is-Correct/m-p/1451161#M799297 <HTML><HEAD></HEAD><BODY><P>Did you resolved the issue, post the solution to help others?</P></BODY></HTML> Mon, 06 Aug 2018 12:50:35 GMT https://community.qlik.com/t5/QlikView/Pivot-Doubles-Values-but-Straight-Table-is-Correct/m-p/1451161#M799297 BalaBhaskar_Qlik 2018-08-06T12:50:35Z