Discussion Board for collaboration related to QlikView App Development.
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?
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
View solution in original post
If you are using Sum(Hours), try using Concat(Hours, ', ')... this will show how many times the same record key might be repeating....
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.