Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

ilcalmo
New Contributor

Trap User connected to limit data visualized

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

5 Replies
ggg
Contributor II

Trap User connected to limit data visualized

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

ilcalmo
New Contributor

Trap User connected to limit data visualized

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

Not applicable

Trap User connected to limit data visualized

I also need to know mor eabout this error .

Bhushan N

ggg
Contributor II

Trap User connected to limit data visualized

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

ilcalmo
New Contributor

Trap User connected to limit data visualized

Maybe I solved.

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

Thanks

Sergio

Community Browser