topic Dynamic Update - duplicates count in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Update-duplicates-count/m-p/953720#M467135 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have used the dynamic update function, to dynamically update my periods into a table.</P><P></P><P>The value MAX_P is based on a variable vPeriod.</P><P></P><P>When I try to do a calculation <STRONG>alt(sum(if(Period = MAX_P, [Page Views]),0)</STRONG>, my count gets duplicated...</P><P></P><P>I know this because when I pull a straight table per period, the sum of the page views are exactly duplicated.</P><P></P><P>Does anyone know why this could happen?</P><P></P><P>Thank you,</P><P>Lucille</P></BODY></HTML> Fri, 04 Dec 2015 13:09:27 GMT 2015-12-04T13:09:27Z Dynamic Update - duplicates count https://community.qlik.com/t5/QlikView/Dynamic-Update-duplicates-count/m-p/953720#M467135 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have used the dynamic update function, to dynamically update my periods into a table.</P><P></P><P>The value MAX_P is based on a variable vPeriod.</P><P></P><P>When I try to do a calculation <STRONG>alt(sum(if(Period = MAX_P, [Page Views]),0)</STRONG>, my count gets duplicated...</P><P></P><P>I know this because when I pull a straight table per period, the sum of the page views are exactly duplicated.</P><P></P><P>Does anyone know why this could happen?</P><P></P><P>Thank you,</P><P>Lucille</P></BODY></HTML> Fri, 04 Dec 2015 13:09:27 GMT https://community.qlik.com/t5/QlikView/Dynamic-Update-duplicates-count/m-p/953720#M467135 2015-12-04T13:09:27Z