topic Taking care of duplicate values while rolling up in QlikView https://community.qlik.com/t5/QlikView/Taking-care-of-duplicate-values-while-rolling-up/m-p/347287#M128489 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In my fact table i have the data in the following format.</P><P></P><P>FactTable:</P><P>Account_id,Geography_sid,Channel_id,Market_id,Product_id,Week_end_date,Units</P><P></P><P>My allignment has the following hierarchy:</P><P>Region---&gt;District----&gt;Territory</P><P></P><P></P><P>Now i have some duplicate values where one Account_id is present in two geography Geography_sid for the same Week_end_date&nbsp; date with same values for Units.</P><P></P><P>Now when i sum the values at territory level i get distinct values in my straight table.But as i drill up the hierarchy for example if i show the sum of units at District level then it adds the duplicate values also.</P><P></P><P>How do i take care of this duplicate values such that when i drill up the hierarchy it sums up the distinct values only. </P></BODY></HTML> Fri, 11 May 2012 11:55:41 GMT 2012-05-11T11:55:41Z Taking care of duplicate values while rolling up https://community.qlik.com/t5/QlikView/Taking-care-of-duplicate-values-while-rolling-up/m-p/347287#M128489 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In my fact table i have the data in the following format.</P><P></P><P>FactTable:</P><P>Account_id,Geography_sid,Channel_id,Market_id,Product_id,Week_end_date,Units</P><P></P><P>My allignment has the following hierarchy:</P><P>Region---&gt;District----&gt;Territory</P><P></P><P></P><P>Now i have some duplicate values where one Account_id is present in two geography Geography_sid for the same Week_end_date&nbsp; date with same values for Units.</P><P></P><P>Now when i sum the values at territory level i get distinct values in my straight table.But as i drill up the hierarchy for example if i show the sum of units at District level then it adds the duplicate values also.</P><P></P><P>How do i take care of this duplicate values such that when i drill up the hierarchy it sums up the distinct values only. </P></BODY></HTML> Fri, 11 May 2012 11:55:41 GMT https://community.qlik.com/t5/QlikView/Taking-care-of-duplicate-values-while-rolling-up/m-p/347287#M128489 2012-05-11T11:55:41Z