topic Re: Stock Store and Stock DC in QlikView https://community.qlik.com/t5/QlikView/Stock-Store-and-Stock-DC/m-p/109854#M17176 <HTML><HEAD></HEAD><BODY><P>Did you try like </P><P></P><P>= Sum(DISTINCT StockDC)</P></BODY></HTML> Mon, 06 Aug 2018 18:41:32 GMT vishsaggi 2018-08-06T18:41:32Z Stock Store and Stock DC https://community.qlik.com/t5/QlikView/Stock-Store-and-Stock-DC/m-p/109853#M17175 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/4003">hic</A>‌,</P><P></P><P>Could you please help me in this issue?</P><P></P><P>I have a Table with Stock Store and Stock Distribution Center.</P><P></P><P>Each distribution center supplies a group of stores.</P><P></P><P>When I put in a pivot table the sum(StockStore) seems ok, but the sum(StockDC) comes with duplicate values.</P><P></P><P>Is there any way there I can have only 1 value of this field.</P><P></P><P>Key is: </P><P>CODCD (ehich is the DC)</P><P>STORELOCATION (which is the store), </P><P>SKU(which is the product)</P><P>Date (date of position of the stock)</P></BODY></HTML> Mon, 06 Aug 2018 18:28:33 GMT https://community.qlik.com/t5/QlikView/Stock-Store-and-Stock-DC/m-p/109853#M17175 yurgelmartina 2018-08-06T18:28:33Z Re: Stock Store and Stock DC https://community.qlik.com/t5/QlikView/Stock-Store-and-Stock-DC/m-p/109854#M17176 <HTML><HEAD></HEAD><BODY><P>Did you try like </P><P></P><P>= Sum(DISTINCT StockDC)</P></BODY></HTML> Mon, 06 Aug 2018 18:41:32 GMT https://community.qlik.com/t5/QlikView/Stock-Store-and-Stock-DC/m-p/109854#M17176 vishsaggi 2018-08-06T18:41:32Z