topic Working with Snapshot dates in QlikView https://community.qlik.com/t5/QlikView/Working-with-Snapshot-dates/m-p/1349985#M616343 <HTML><HEAD></HEAD><BODY><P>Every day we snapshot our operations to store our hours.&nbsp; Currently when we want to compare released work on the "snapshot" date it was released. </P><P></P><P>I have a variable that calls out the released snap date: =date(aggr(min({&lt;STATUS={'R'}&gt;}SnapShotDate),%KEY_OPERATION))</P><P>and a variable for the equation:&nbsp; <SPAN style="font-size: 13.3333px;">sum(aggr(sum({&lt;SnapShotDate={'$(vDateR)'}&gt;}EAC),%KEY_OPERATION))</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">The formula works perfectly to the %key_operation only if that distinct <SPAN style="font-size: 13.3333px;">%key_operation is selected.&nbsp; if it is just the raw data the computation of that formula is 0.</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Can anyone help with this problem?&nbsp; see attached example.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Thank you.</SPAN></P></BODY></HTML> Thu, 03 Aug 2017 19:51:40 GMT Anonymous 2017-08-03T19:51:40Z Working with Snapshot dates https://community.qlik.com/t5/QlikView/Working-with-Snapshot-dates/m-p/1349985#M616343 <HTML><HEAD></HEAD><BODY><P>Every day we snapshot our operations to store our hours.&nbsp; Currently when we want to compare released work on the "snapshot" date it was released. </P><P></P><P>I have a variable that calls out the released snap date: =date(aggr(min({&lt;STATUS={'R'}&gt;}SnapShotDate),%KEY_OPERATION))</P><P>and a variable for the equation:&nbsp; <SPAN style="font-size: 13.3333px;">sum(aggr(sum({&lt;SnapShotDate={'$(vDateR)'}&gt;}EAC),%KEY_OPERATION))</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">The formula works perfectly to the %key_operation only if that distinct <SPAN style="font-size: 13.3333px;">%key_operation is selected.&nbsp; if it is just the raw data the computation of that formula is 0.</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Can anyone help with this problem?&nbsp; see attached example.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Thank you.</SPAN></P></BODY></HTML> Thu, 03 Aug 2017 19:51:40 GMT https://community.qlik.com/t5/QlikView/Working-with-Snapshot-dates/m-p/1349985#M616343 Anonymous 2017-08-03T19:51:40Z Re: Working with Snapshot dates https://community.qlik.com/t5/QlikView/Working-with-Snapshot-dates/m-p/1349986#M616344 <HTML><HEAD></HEAD><BODY><P>Can you make it Case study?</P></BODY></HTML> Fri, 04 Aug 2017 01:27:38 GMT https://community.qlik.com/t5/QlikView/Working-with-Snapshot-dates/m-p/1349986#M616344 Anil_Babu_Samineni 2017-08-04T01:27:38Z Re: Working with Snapshot dates https://community.qlik.com/t5/QlikView/Working-with-Snapshot-dates/m-p/1349987#M616345 <HTML><HEAD></HEAD><BODY><P>What do you mean a case study?</P></BODY></HTML> Tue, 08 Aug 2017 16:35:14 GMT https://community.qlik.com/t5/QlikView/Working-with-Snapshot-dates/m-p/1349987#M616345 Anonymous 2017-08-08T16:35:14Z