topic Re: How to get to know the userName in QlikView

How to get to know the userName

Tue, 10 Jun 2014 10:29:15 GMT

Hi all,

I want to get the user(CAL) which is currently accessing the report.

In report, I want to restrict the user dynamically, so that i do not need to use the section access.

How can i get to know while report loading, which user is accessing the report.

Thanks in advance.

Re: How to get to know the userName

MK_QSL — Tue, 10 Jun 2014 10:37:18 GMT

Type

=OSUSER()

in text box object

Re: How to get to know the userName

amit_saini — Tue, 10 Jun 2014 10:41:47 GMT

Hi Keshav,

Go to QMC-->Status-->QVS Statics-->Documents and Users , here you will get to know who is accessing which particular report.

Thanks,
AS

Re: How to get to know the userName

Tue, 10 Jun 2014 10:46:55 GMT

Hi Manish,

Thanks for replying.

Let me clarify you this,

Suppose I have below two machines:

M1 - Server

M2 - CAL

Now i am trying to fetch the report via web browser.

Since the CAL is assigned for M2(Either user or machine), it will be able to access the report.

If I use osuser(), it will return me entries from M1.

But I want to know the entry for M2, as I need to restrict the CALs dynamically in the report.

I am not sure about using QVuser() in the report.

Will there be any to do so.

Thanks in advance.

Re: How to get to know the userName

ashfaq_haseeb — Tue, 10 Jun 2014 10:48:15 GMT

Hi,

go to chart properties --> layout --> select conditional and write below code.

if(OSUser()='<domain>\<username>',1,0)

hope it helped.

Regards

ASHFAQ

Re: How to get to know the userName

Tue, 10 Jun 2014 10:48:31 GMT

Thanks for reply Amit.

This server side configuration I know,

but while accessing the report, I want to know in the report only, which CAL is currently accessing the report.

If there is such way, please do tell me.

Thanks in advance.

Re: How to get to know the userName

Tue, 10 Jun 2014 10:49:16 GMT

Hi Ashfaq,

Thanks for replying.

Let me clarify you this,

Suppose I have below two machines:

M1 - Server

M2 - CAL

Now i am trying to fetch the report via web browser.

Since the CAL is assigned for M2(Either user or machine), it will be able to access the report.

If I use osuser(), it will return me entries from M1.

But I want to know the entry for M2, as I need to restrict the CALs dynamically in the report.

I am not sure about using QVuser() in the report.

Will there be any to do so.

Thanks in advance.

Re: How to get to know the userName

ashfaq_haseeb — Tue, 10 Jun 2014 10:54:29 GMT

Hi Keshav.

Do you use local directory or active directory to authenticate users?

Ok, do one thing use a text box and write =osuser() save you application.

now logged in to access point with m2/Cal user, tell me what does the text box return?

Regards

ASHFAQ

Re: How to get to know the userName

Tue, 10 Jun 2014 11:02:03 GMT

Yes, I did that.

I returned me the server's user id for which qlikview server is running.

Re: How to get to know the userName

ashfaq_haseeb — Tue, 10 Jun 2014 11:10:39 GMT

Ok that's great.

Now from access point export the test box you see to excel.

now open the application in desktop.

go to any chart click on properties --> layout --> select conditional and write below code.

if(OSUser()='<domain>\<username>',1,0)

<domain>\<username> replace the same with exported value.

Tell me if it works by logging in with another user.

Hope it helped.

Regards

ASHFAQ

Re: How to get to know the userName

Tue, 10 Jun 2014 17:02:58 GMT

Hi Ashfaq,

Thanks for replying.

Now I used the same on Qlikview server. But whenever the document is called from some Browser,

It is not triggering the DocumentLoad trigger. So since OSUser() is different, it is not able to put this

in a variable or field.

Is there anyway so that I can trigger some event on DocumentAccess in browser.

Thanking in advance.