Discussion Board for collaboration related to QlikView Deployment.
I need to filter data visualized in a QV report based on user logged. One specific user can see information of only one specific Organization.
How can I trap the user connected in order to link him with his Organization and create the specific filter?
PS: User log in with publisher.
The solution for this is Section Access in the script to limit the data based on reduction of data for each and every user.Here is a very basic example. Copy/paste into an application reload and save.Log in with the different users and you will see the reduction for each user.For more information, search the forum for "Section Access", there are a lot of good solutions posted by our members.
Section Access;LOAD * INLINE [ ACCESS, USERID, PASSWORD, ORG ADMIN, ADMIN, ADMIN USER, USER1, 1, USA USER, USER2, 2, SWE USER, USER3, 3, GER];Section Application;LOAD * INLINE [ ORG, SALES USA, 1000 USA, 2000 USA, 3000 SWE, 4000 SWE, 5000 GER, 6000];
Thank you Gustav !
The only problem is that I'm trying to use it now on a client version of QV, but when i reload data with Session access all graphs are marked with 'Allocated memory exceeded''.
is it a known issue? Is it possible to bypass the problem?
I also need to know mor eabout this error .
"Allocated Memory Exceeded" can be caused by many things. Calculated dimensions, syn-keys, data structure, resource heavy expressions and so forth.I need more information about build number for the products involved and preferably the document to be able to determine where the error is.Regards,Gustav
Maybe I solved.
The problem was due to the fact that i didn't wrote section Application part.