topic Sum Problem with Chart in QlikView

Sum Problem with Chart

chris_johnson — Thu, 25 Aug 2011 12:30:46 GMT

Hi all,

I've got a problem that is making me cry. Below is the entries from a table box for a particular job on my report. As you can see the Total Price fields add up to about 1073.

The problem is that as soon as I try to put this into a chart it multiplies some of the lines by 5:

As you can see, the Total Price field looks ok but the Total Price Sum column (using expression "sum({<[Table Source]={'Res Estimate'}>} [Total Price])")

calcuates the value to exactly 5 times more. Below is a screenshot of the table structure, it's pretty simple:

I'm completely stumped. Does anyone have any ideas I could try? Or any suggestions as to what might be going wrong?

Regards,

Chris

Sum Problem with Chart

swuehl — Thu, 25 Aug 2011 12:58:35 GMT

Chris,

please note that AFAIK the table box will not show duplicate rows.

I assume you indeed have 5 entries in your table where the sum is 5x the single row value (as you stated, not for all Job No / Codes, but for some).

I think you need to get finer detail of your data, e.g. by adding approriate dimensions to your table, to see where these duplicate rows come from. You could also try to use count() to verify that my assumption is correct (e.g. count([Total Price]) )

Stefan

Sum Problem with Chart

klausskalts — Thu, 25 Aug 2011 13:20:40 GMT

Trouble shooting tip:

Select one "problem row" in your chart
Identify all data field names on a "problem row" in your chart
Create a table boc containing all the data fields from 2

Your table box will now show which data fields contain multiple values and thereby make you cry

Sum Problem with Chart

klausskalts — Thu, 25 Aug 2011 13:21:46 GMT

.. and then you either:

Clean up your data model

or
Change your formula