topic Re: How to use qvuser() in qlikview? in QlikView

How to use qvuser() in qlikview?

Sun, 07 Jun 2015 11:52:21 GMT

hi,

I created qv application.and I want to use qv user() function in my qv application.I do not know qvuser () in qlikview .pls tell me out what is qv user() ? and how to use qv user () in qlikview.can any one explain to me with example.

Thankyou,

regards

madhu

Re: How to use qvuser() in qlikview?

kaushiknsolanki — Sun, 07 Jun 2015 11:56:07 GMT

HI Madhu,

QvUser() returns you the user by which you have open the QlikView application.

This function is used when you have applied the section access in your application.

Regards,

Kaushik Solanki

Re: How to use qvuser() in qlikview?

Sun, 07 Jun 2015 12:02:25 GMT

Thankyou kaushik solanki.

Re: How to use qvuser() in qlikview?

Sun, 07 Jun 2015 12:05:29 GMT

hello kaushik solanki .I understand but I do not know how to use qvuser () in qlikiview.pls can you send small example.

kaushik solanki.plss

Regards

madhu.

Re: How to use qvuser() in qlikview?

ToniKautto — Sun, 07 Jun 2015 12:10:25 GMT

QvUser() can be used to identify the current user, when you are using Section Access and USERID field.

If you do not user Section Access and USERID, this function is of no value to you.

Re: How to use qvuser() in qlikview?

kaushiknsolanki — Sun, 07 Jun 2015 12:11:45 GMT

Hi,

All you have to do is create a text box and put text as =QvUser()

This will show you the user name.

Regards,

Kaushik Solanki

Re: How to use qvuser() in qlikview?

Sun, 07 Jun 2015 12:22:12 GMT

Thankyou kaushik solanki.this is my data .which place i use qvuser() pls tell me kaushik solanki

SECTION Access;

ACCESS:

LOAD * Inline [

ACESS,USERID,PRODUCT

ADMIN,MADHU,*

USER,KALYAN,SAMSUNG

USER,KUMAR,SONY

];

SECTION Application;

LOAD * Inline [

USERID,CH01,CH02

MADHU,1,1

KALYAN,1,0

KUMAR,0,1

];

LOAD * Inline [

USERID,PRODUCT,PRICE

KALYAN,SAMSUNG,50000

KUMAR,SONY,40000

];

Re: How to use qvuser() in qlikview?

Sun, 07 Jun 2015 12:23:53 GMT

Thank you Toni kautto, this is my data.pls tell me how to use qvuser function according to my data.

SECTION Access;

ACCESS:

LOAD * Inline [

ACESS,USERID,PRODUCT

ADMIN,MADHU,*

USER,KALYAN,SAMSUNG

USER,KUMAR,SONY

];

SECTION Application;

LOAD * Inline [

USERID,CH01,CH02

MADHU,1,1

KALYAN,1,0

KUMAR,0,1

];

LOAD * Inline [

USERID,PRODUCT,PRICE

KALYAN,SAMSUNG,50000

KUMAR,SONY,40000

];

Re: How to use qvuser() in qlikview?

kaushiknsolanki — Sun, 07 Jun 2015 12:24:30 GMT

Hi,

as I said earlier, you need to use this function on front end (on Sheet)

Using the Text Object.

Regards,

Kaushik Solanki

Re: How to use qvuser() in qlikview?

ToniKautto — Sun, 07 Jun 2015 12:27:01 GMT

QVUser() is not a script function. It will tell you the current user based on your section access, hence this is first after a user has successfully logged in.

Re: How to use qvuser() in qlikview?

Sun, 07 Jun 2015 12:30:01 GMT

thank you kaushik solanki now I use this function.

Re: How to use qvuser() in qlikview?

Sun, 07 Jun 2015 12:31:26 GMT

thankyou toni kautto.pls tell me how to write function according to my sheet pls tell me.

Re: How to use qvuser() in qlikview?

ToniKautto — Sun, 07 Jun 2015 12:35:38 GMT

What do you mean how to write the function?

It is a function, you use it when ever you need the USERID value of the current user. If you do have a need to show or use the USERID value, then you use the function. Otherwise you simply do not use the function. What exactly is it that you can not get to work when you have tried the function?

Re: How to use qvuser() in qlikview?

Anonymous — Sun, 07 Jun 2015 13:23:29 GMT

See my responses to your other question:CAN ANY ONE EXPLAIN THIS SCRIPT?

Re: How to use qvuser() in qlikview?

Sun, 07 Jun 2015 16:33:17 GMT

Thankyou michael

Re: How to use qvuser() in qlikview?

avnish319 — Wed, 18 Jul 2018 12:32:08 GMT

OSUser() fuction can be used when there is no section access.