I am having problem by not showing latest information in Qlikview everytime i re-open the QVW. I tried to reload a few times and save+close and open a few times, but the data always reverted back to old info.
I am able to solve this problem by unchecked 'Initial Data Reduction Based on Section Access', but my data is quite sensitive for some user. I have also tried to clone the QVW to a new QVW. But the result is still the same. Unable to show latest information.
Do you have any idea about this issue? Looking forward to your reply. Big THANKS in advance for the help.
It sounds that your section access tables isn't updated in regard to the data-update from your last reload - and then those data haven't a valid authorization and are then removed by opening the application.
Jeff, best I can do for you on this one is point you to a couple of Design Blog post that will hopefully allow you to check your work here, as Marcus is on the right track, there has to be an issue with your Section Application link via your dynamic reduction field(s) in the Section Access load that is restricting things...
There are some additional links at the bottom of the above post specifically related to dynamic data reduction, so be sure to visit those too, but hopefully reviewing these will help you figure out what you have done incorrectly and get it fixed. The fact things work when you uncheck reduction signals the issue is in the data model and dynamic reduction... One other trick you can use here to better see things is comment just the Section Access line of the script, that lets the Section Access table be visible in the data model at that point, which can make troubleshooting things a lot easier in these situations.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.