topic Pivot Table values repeated in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-values-repeated/m-p/873725#M1009961 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px;">Absolute beginner here and may be a silly question but,</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">I am trying to build a chart with ParentStockItem -&gt; Stock Items -&gt; Serial Lot Numbers -&gt; Lot Locations. I would like the values of available and on hand to be shown in the chart.&nbsp; 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.&nbsp; I am sure this is a coding error and if someone could help me fix it that would be awesome.</P></BODY></HTML> Tue, 05 May 2015 04:07:59 GMT 2015-05-05T04:07:59Z Pivot Table values repeated https://community.qlik.com/t5/QlikView/Pivot-Table-values-repeated/m-p/873725#M1009961 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px;">Absolute beginner here and may be a silly question but,</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">I am trying to build a chart with ParentStockItem -&gt; Stock Items -&gt; Serial Lot Numbers -&gt; Lot Locations. I would like the values of available and on hand to be shown in the chart.&nbsp; 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.&nbsp; I am sure this is a coding error and if someone could help me fix it that would be awesome.</P></BODY></HTML> Tue, 05 May 2015 04:07:59 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-values-repeated/m-p/873725#M1009961 2015-05-05T04:07:59Z Re: Pivot Table values repeated https://community.qlik.com/t5/QlikView/Pivot-Table-values-repeated/m-p/873726#M1009962 <HTML><HEAD></HEAD><BODY><P>check your joins and associations with facts and locations</P></BODY></HTML> Tue, 05 May 2015 08:17:58 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-values-repeated/m-p/873726#M1009962 Anonymous 2015-05-05T08:17:58Z