topic Re: Straight Table Sum returns different value than Table Box in QlikView

Straight Table Sum returns different value than Table Box

Anonymous — Wed, 23 Aug 2017 14:52:06 GMT

Hello,

I've run into something confusing that I can't seem to sort. I have a data set that returns a summed value (straight table) greater than the sum of the same records in a table box.

Here is an image as an example:

The name is the same throughout (blotted for privacy reasons). I've added a record key to identify any duplicates but I do not see any (this was my issue previously due to a poor join).

Does anyone have any suggestions on how I can troubleshoot this cause?

Thanks,

Channing

Re: Straight Table Sum returns different value than Table Box

sunny_talwar — Wed, 23 Aug 2017 14:53:23 GMT

It seems to be a data modeling issue... it seems that each row is repeated 5 times which might be showing up in the straight table

Re: Straight Table Sum returns different value than Table Box

sunny_talwar — Wed, 23 Aug 2017 14:57:20 GMT

If you are using Sum(Hours), try using Concat(Hours, ', ')... this will show how many times the same record key might be repeating....

Re: Straight Table Sum returns different value than Table Box

Anonymous — Thu, 24 Aug 2017 17:25:50 GMT

Issue: Duplicates in one table - upon creation of the relationship it was summing multiple values giving me an incorrect 240 hours (5 records of 48 hrs)

I fixed the data source to have distinct values and now my model is working appropriately.

I was focused on the function and not the model thank you for bringing clarity to that.

Channing