Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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?

Life is so rich, and we need to respect to the life !!!
New Contributor III

Re: Working with Snapshot dates

What do you mean a case study?