topic Re: pivot table sum problems in QlikView

pivot table sum problems

Mon, 30 Jul 2012 10:10:21 GMT

hi,

I have quiet a big problem. I have a pivot table and I am trying to sum my profit and it is always double the profit. I dont understand cause I also have a tablebox and it always shows me one entry on a specific date. but in the pivot table my profit is still double to the profit in my pivottable.

here is a screenshot. hopefully it helps for the understanding

Re: pivot table sum problems

Anonymous — Mon, 30 Jul 2012 10:22:21 GMT

Hi,

I'm pretty sure you've managed to load the data twice. Perhaps due to automatic concatenation.

Table Boxes only show distinct combinations of the values of the fields in the object.

Check that you're only loading the data set once.

Re: pivot table sum problems

Mon, 30 Jul 2012 10:45:35 GMT

can i enable the distinct setting somehow?

Re: pivot table sum problems

Mon, 30 Jul 2012 11:21:09 GMT

Hi,

I think the key's are getting created twice for the same record or as Johannes has mentioned the data set has been loaded twice. Try by putting distinct in the script where the common key field is defined between tables.