I have hidden some extra/test sheets in my qlikview document by setting the visibility condition as 0. It works fine on the desktop version. However when I open the document from access point the hidden sheets are visible.
Another strange thing is that every time I make a selection it toggles between showing and hiding those sheets.
The only thing that I noticed that looked weird on the server is that there are 2 ".shared" files present for this document. e.g. Test.qvw.shared, Test (1).qvw.shared.
Please note that the options "Show all sheets" and "Admin override security" are unchecked.
I just can't figure out why this is happening... and it's quite urgent to resolve.. so any help is appreciated !!!