topic Dimensionality ? Wrong sum in Pivot in QlikView https://community.qlik.com/t5/QlikView/Dimensionality-Wrong-sum-in-Pivot/m-p/181201#M47314 <HTML><HEAD></HEAD><BODY><P>I have a problem I can't seem to find the solution to.</P><P>I have a pivot table showing turnover and invoiced contra budget. The turnover tallies but the invoiced shows wrong amount on detail level (ok on Total).</P><P>The reason for this is that on budget and turnover level I have a Claim_Type at Client_Id level and one of the Client_Ids (the ones ending on 1) have several Claim_Type (1 and 9). This Claim_Type dosen't exists in the Invoice table which is based solely on Client_Id. Therefore QV dosen't know which Claim_Type to put invoiced amount on and puts it on both.</P><P>The amount on Claim_Type 9 with the red ring around it in the enclosed is incorrect.</P><P>I have tried to fake a Claim_Type in the invoice table and use it in expression, but it just multiplies the invoiced amount. I have also tried to make a Dimensionality in order to only get total amount but it requires that the user then select invoice date also besides budget date which then de-selects Client_ids where invoiced =0 which is also wrong.</P><P>Anybody has any ideas who to do this ?</P><P></P></BODY></HTML> Wed, 09 Dec 2009 17:37:09 GMT 2009-12-09T17:37:09Z Dimensionality ? Wrong sum in Pivot https://community.qlik.com/t5/QlikView/Dimensionality-Wrong-sum-in-Pivot/m-p/181201#M47314 <HTML><HEAD></HEAD><BODY><P>I have a problem I can't seem to find the solution to.</P><P>I have a pivot table showing turnover and invoiced contra budget. The turnover tallies but the invoiced shows wrong amount on detail level (ok on Total).</P><P>The reason for this is that on budget and turnover level I have a Claim_Type at Client_Id level and one of the Client_Ids (the ones ending on 1) have several Claim_Type (1 and 9). This Claim_Type dosen't exists in the Invoice table which is based solely on Client_Id. Therefore QV dosen't know which Claim_Type to put invoiced amount on and puts it on both.</P><P>The amount on Claim_Type 9 with the red ring around it in the enclosed is incorrect.</P><P>I have tried to fake a Claim_Type in the invoice table and use it in expression, but it just multiplies the invoiced amount. I have also tried to make a Dimensionality in order to only get total amount but it requires that the user then select invoice date also besides budget date which then de-selects Client_ids where invoiced =0 which is also wrong.</P><P>Anybody has any ideas who to do this ?</P><P></P></BODY></HTML> Wed, 09 Dec 2009 17:37:09 GMT https://community.qlik.com/t5/QlikView/Dimensionality-Wrong-sum-in-Pivot/m-p/181201#M47314 2009-12-09T17:37:09Z Dimensionality ? Wrong sum in Pivot https://community.qlik.com/t5/QlikView/Dimensionality-Wrong-sum-in-Pivot/m-p/181202#M47315 <HTML><HEAD></HEAD><BODY><P>I found the solution to my problem. Instead of Sum(if(..... it should be If(.... , sum.... This makes the correct summation:</P><P>IF(CLAIM_TYPE=9, 0, SUM(if(TurnoverBudgetMonth=Ledgerinvoice_InvoiceMonthYear,(LedgerInvoice_Amount))))</P></BODY></HTML> Thu, 10 Dec 2009 15:15:43 GMT https://community.qlik.com/t5/QlikView/Dimensionality-Wrong-sum-in-Pivot/m-p/181202#M47315 2009-12-10T15:15:43Z