topic Peek Function in QlikView https://community.qlik.com/t5/QlikView/Peek-Function/m-p/75461#M788990 <HTML><HEAD></HEAD><BODY><P>Hi friends, </P><P></P><P></P><P>I am trying to use peek function to get calculation of difference in DFC </P><P></P><P>Sum(if(match(Week&amp; text(Material) &amp; text([Customer Loc]), %Key)&gt;0,DFC,0)) - Sum(if(peek(match(Week&amp; text(Material) &amp; text([Customer Loc]), %Key)&gt;0),DFC,0))as WeekDFC</P><P></P><P>Attached a sample file for reference. of Data, </P><P></P><P>Basically i am trying to calculate calendar days using dFC difference between every week for that particular product and location. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT bushpalaamarnat 2020-11-25T16:16:04Z Peek Function https://community.qlik.com/t5/QlikView/Peek-Function/m-p/75461#M788990 <HTML><HEAD></HEAD><BODY><P>Hi friends, </P><P></P><P></P><P>I am trying to use peek function to get calculation of difference in DFC </P><P></P><P>Sum(if(match(Week&amp; text(Material) &amp; text([Customer Loc]), %Key)&gt;0,DFC,0)) - Sum(if(peek(match(Week&amp; text(Material) &amp; text([Customer Loc]), %Key)&gt;0),DFC,0))as WeekDFC</P><P></P><P>Attached a sample file for reference. of Data, </P><P></P><P>Basically i am trying to calculate calendar days using dFC difference between every week for that particular product and location. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Peek-Function/m-p/75461#M788990 bushpalaamarnat 2020-11-25T16:16:04Z