Using QVUser() against loaded data

[#1]

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

[#2]

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

[#3]

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