topic How to use point in time reporting within a pivot table in QlikView https://community.qlik.com/t5/QlikView/How-to-use-point-in-time-reporting-within-a-pivot-table/m-p/146263#M590217 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I would like to calculate a balance <STRONG>till</STRONG> the end of the week used in a dimension of a pivot table.<BR />What do I have?<BR />1) A pivot table with 1 dimension: Week<BR />2) An expression to calculate the balance amount on a bankaccount till the end of that week.<BR /><BR />The following set analysis syntax works fine BUT, I must select one week to get the right balance.</P><P></P><P></P><P>=</P><P>sum({ 1 &lt;GbkMut.gbmDatum={"&lt;=$(=DATE(Weekend(MAX(%PeriodeDatum_key)),'YYYY-MM-DD'))"} &gt; } TOTAL if(Match(GbkMut.gbmReknr, 1040,1050), GbkMut.gbmBedrag,0))</P><BR /><BR /> <BR /><BR /> <P>What I want is a balance calculation for every weekend(sunday) disregarding <STRONG>the start</STRONG> of <STRONG></STRONG>the dimension. Can somone help!?</P></BODY></HTML> Tue, 09 Jun 2009 16:11:19 GMT richard 2009-06-09T16:11:19Z How to use point in time reporting within a pivot table https://community.qlik.com/t5/QlikView/How-to-use-point-in-time-reporting-within-a-pivot-table/m-p/146263#M590217 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I would like to calculate a balance <STRONG>till</STRONG> the end of the week used in a dimension of a pivot table.<BR />What do I have?<BR />1) A pivot table with 1 dimension: Week<BR />2) An expression to calculate the balance amount on a bankaccount till the end of that week.<BR /><BR />The following set analysis syntax works fine BUT, I must select one week to get the right balance.</P><P></P><P></P><P>=</P><P>sum({ 1 &lt;GbkMut.gbmDatum={"&lt;=$(=DATE(Weekend(MAX(%PeriodeDatum_key)),'YYYY-MM-DD'))"} &gt; } TOTAL if(Match(GbkMut.gbmReknr, 1040,1050), GbkMut.gbmBedrag,0))</P><BR /><BR /> <BR /><BR /> <P>What I want is a balance calculation for every weekend(sunday) disregarding <STRONG>the start</STRONG> of <STRONG></STRONG>the dimension. Can somone help!?</P></BODY></HTML> Tue, 09 Jun 2009 16:11:19 GMT https://community.qlik.com/t5/QlikView/How-to-use-point-in-time-reporting-within-a-pivot-table/m-p/146263#M590217 richard 2009-06-09T16:11:19Z