Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

New Contributor III

Working with Snapshot dates

Every day we snapshot our operations to store our hours.  Currently when we want to compare released work on the "snapshot" date it was released.

I have a variable that calls out the released snap date: =date(aggr(min({<STATUS={'R'}>}SnapShotDate),%KEY_OPERATION))

and a variable for the equation:  sum(aggr(sum({<SnapShotDate={'$(vDateR)'}>}EAC),%KEY_OPERATION))

The formula works perfectly to the %key_operation only if that distinct %key_operation is selected.  if it is just the raw data the computation of that formula is 0.

Can anyone help with this problem?  see attached example.

Thank you.

2 Replies

Re: Working with Snapshot dates

Can you make it Case study?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
New Contributor III

Re: Working with Snapshot dates

What do you mean a case study?