Hi, one of my qlikview systems uses a security login system, users put in their ID and Password and the data they can see is restricted. However the problem lies in the fact that if the database with user IDs and Passwords change it isn't picked up by qlikview until the QVW data is reloaded. Is there anyway I can tell qlikview to load/read from the database directly everytime it loads so it is always updating with the latest information? Bear in mind though that it takes 30 seconds for this QVW to reload its data each time! Help!
Subj to your environment: updating of the database may fire a macro, which starts refresh. Stupid solution would be to refresh each 1-10 minutes. Another variant might be to have a batch running each xxx mins, checking if the database has changed - if positive: refresh, if negative: stay qool (wanted to implement this since long, but not found the time so far)
