Absolute beginner here and may be a silly question but,
I am trying to build a chart with ParentStockItem -> Stock Items -> Serial Lot Numbers -> Lot Locations. I would like the values of available and on hand to be shown in the chart. I have gotten to the point where I am getting all the correct data in the chart except for when I expand into the lot locations I get repeated numbers as if the Serial Lots and Locations are not connected. I am sure this is a coding error and if someone could help me fix it that would be awesome.
That sounds like a problem in your data model. Open the Table Viewer to see if the tables are associated correctly. Qlikview associates tables on the field names the tables have in common. Qlikview is case sensitive with regards to field names. Perhaps you have to rename some fields.
You have a loop in your data model. There should be only one path to each table. Because of that loop the tables involved are loosely coupled. That's almost certainly the cause of the duplication you see. You need to resolve the loop. Perhaps you can merge the INSerialLot and INSerialLotLocationSum... tables.
