topic Trap User connected to limit data visualized in QlikView

Trap User connected to limit data visualized

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hello,

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.

Thanks

Sergio

Trap User connected to limit data visualized

Gustav_Guldberg — Sat, 19 Dec 2009 04:00:53 GMT

Hi Sergio,

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
];

Regards,

Gustav

Trap User connected to limit data visualized

Anonymous — Tue, 22 Dec 2009 17:39:24 GMT

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?

Kind Regards,

Sergio

Trap User connected to limit data visualized

Tue, 22 Dec 2009 17:48:50 GMT

I also need to know mor eabout this error .

Bhushan N

Trap User connected to limit data visualized

Gustav_Guldberg — Tue, 22 Dec 2009 20:46:59 GMT

Hi,

"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

Trap User connected to limit data visualized

Anonymous — Wed, 23 Dec 2009 16:24:17 GMT

Maybe I solved.

The problem was due to the fact that i didn't wrote section Application part.

Thanks

Sergio