topic Using QVUser() against loaded data in QlikView

Using QVUser() against loaded data

Mon, 14 Jun 2010 10:01:39 GMT

Hi All,

All individuals accessing my qvw files do so through IE. That passes in a unique ID. Using QVUser() I can identify who is logging in.

In a loaded table I have a U_ID, which is the same as what gets passed in from IE. This table then contains details about the user. Such as U_Type.

What I can not seem to do is use QVUser() and query it against U_ID to return the users other information.

Could anyone give me a pointer?

Thanks
Lee

Using QVUser() against loaded data

Mon, 14 Jun 2010 14:33:54 GMT

Hi,

I'm not sure to really understand what you want to do. But if you want to display different infos depending off the connected user, I think you should use the file security system. Please refer to chapters 26.3 up to 26.6 of the QlikView reference manual

Hopes it helps

Best regards

Using QVUser() against loaded data

Tue, 15 Jun 2010 08:48:32 GMT

Hi Bertrand,

Thanks for your help. I have security access working correctly, reducing data etc. What I can not seem to do is get QVUser() to match against the users unique ID even though they are the same.

So I am looking for something like - if(QvUser() = U_ID, U_Type), U_ID being any records in that field with the same ID as what QVUser is presenting.

Hope that makes sense.

Lee