If the Reviewers logs into the application, data should be available till the latest quarter data or with the Flag values is "N" or we can consider that as current Quarter.
If the Users logs in, data should be available only till the quarter value where Flag value is "Y".
And if the Reviewers give sign off by updating the Flag column in database as "Y" in 2017Q3 column, once the data refresh is done, both the users and Reviewers
should see the 2017Q3 quarter data with the Flag column "Y".
How can we achieve this pls provide your solution with QVW file
Which means that when all Quarters have been reviewed and signed off (all Quarters get a 'Y' in the DB), all reviewers will be locked out of the document (no more data left to review)?
peter once Reviewers give sign off by updating the Flag column in database as "Y" in 2017Q3 column, suppose in future he want to review the reviewed the old sign off means how he will see it.
A moment ago you stated that Reviewers should not see the old quarter data, "... but Reviewers have only to see latest quarter". Which will it be?
Section Access is a technique to make data available to specific users, and not to other users. In the end, what you do with that data in your document is up to you as a developer. If I understand you correctly, Reviewers should focus on data to be reviewed, but should also get a chance to revisit older data (possibly for benchmarking or comparisons or whatever). In QlikView, you can use set analysis to fill a specific object with data-to-be-reviewed (Flag = N). This object may well be empty when a particular Reviewer has finished his duties in time. Other objects on other sheets however may still show historical data or other aggregations based on quarterly results, just as they do for regular Users.
IMHO you should first make sure that you have a correct and consistent description of the expected behavior of your document for different user groups. Only after that definition has been agreed upon, start implementing a solution. In many cases you will find out that the actual solution is way simpeler than you initially thought. Especially in QlikView.
