topic Re: How to Trigger a set variable based on USERID in QlikView

How to Trigger a set variable based on USERID

Wed, 20 Apr 2016 08:29:34 GMT

Namaste all

I have successfully implemented section access on my file and uploaded it on the server with the help of you guys..

Please help me with the following trigger settings..

I have implemented section access in my file,

But, I am unable to Trigger a variable based on USERID,

I will explain my scenario.

I have three sheets in my document L1, L2, L3 and i have users user1, user2, user3 and the variable i want to trigger is LineNo.

I want variable LineNo to set to 1 when i open as user1, LineNo=2 when i login as user2 , LineN=3 when i login as user3.

please find the attached qvw file and excel file to check my code and trigger settings..

Please see my if condition, at the trigger->document properties->onopen->set variable

Admin credentials:

Username : Rahul

PAssword : Rahul101

section access is not hidden

Thank you in advance

Re: How to Trigger a set variable based on USERID

sunny_talwar — Wed, 20 Apr 2016 08:34:15 GMT

Try this:

=if(USERID='user1',1,

if(USERID='user2',2,

if(USERID='user3',3,0)))

Re: How to Trigger a set variable based on USERID

jerrysvensson — Wed, 20 Apr 2016 08:40:30 GMT

And OnOpen trigger will of course only work if you use Plugin as client.

Re: How to Trigger a set variable based on USERID

Wed, 20 Apr 2016 08:40:59 GMT

Thanks for quick reply

still it is not working , when i login as user

please see the attached file with the changes

Thank you

Re: How to Trigger a set variable based on USERID

sunny_talwar — Wed, 20 Apr 2016 08:41:33 GMT

Infact this:

=if(USERID='USER1',1,

if(USERID='USER2',2,

if(USERID='USER3',3,0)))

Re: How to Trigger a set variable based on USERID

kaushiknsolanki — Wed, 20 Apr 2016 08:43:26 GMT

Hi,

try this expression. in Trigger

=if(Qvuser()='USER1',1,

if(Qvuser()='USER2',2,

if(Qvuser()='USER3',3,0)))

Regards,

Kaushik Solanki

Re: How to Trigger a set variable based on USERID

sunny_talwar — Wed, 20 Apr 2016 08:43:39 GMT

Try the attached

Re: How to Trigger a set variable based on USERID

Wed, 20 Apr 2016 08:45:49 GMT

Hi Jerry,

Thanks for the quick reply

could you explain me this a little bit more or please provide any links to how to do it.

at the moment i am working on qlikview personal edition which is liecensed, and after i will upload the file onto the server to access from browser using access point..

could you please explain me which plugin to use, how to make it work on both browser and the QV personal edition

Thanks in advance

Re: How to Trigger a set variable based on USERID

kkkumar82 — Wed, 20 Apr 2016 08:48:19 GMT

As Koushik suggested use QVuser in a text box for a particular user and check whether you are getting the required users or not

Re: How to Trigger a set variable based on USERID

jerrysvensson — Wed, 20 Apr 2016 08:59:59 GMT

It works on Personal Edition (Developer).

When uploaded to server you can access it from Accesspoint. There you can use Plugin (ActiveX Component) or WebView (Ajax). Using Webview as client OnOpen will not trigger. See reference manual.

Re: How to Trigger a set variable based on USERID

Wed, 20 Apr 2016 09:06:31 GMT

Thank you and gr8 sir, it is working fine when i login user

but have you seen , when i login as admin, the first sheet is not showing the correct LineNo

please see by login as Admin and you will see the different current line for the first sheet that you open,

than when you click on other sheet it will get the correct current line, because it uses the sheet level trigger

I think , i explained you my problem clearly.. please ask me if you don't understand

Thank you

Re: How to Trigger a set variable based on USERID

sunny_talwar — Wed, 20 Apr 2016 09:08:51 GMT

As Rahul

As User1

Re: How to Trigger a set variable based on USERID

kkkumar82 — Wed, 20 Apr 2016 09:09:28 GMT

I think the conditions are written only for USER1, USER2 and USER3

Re: How to Trigger a set variable based on USERID

sunny_talwar — Wed, 20 Apr 2016 09:10:29 GMT

But there is a false statement which defaults to 0. I think it is working at my end as I would expect

=if(USERID='USER1',1,

if(USERID='USER2',2,

if(USERID='USER3',3,0)))

Re: How to Trigger a set variable based on USERID

Wed, 20 Apr 2016 09:14:37 GMT

Hi sunny

I am seeing the current line as 0, because i think, we dont have any logic for trigger when we login as admin, could you please fix this, than i am done

Re: How to Trigger a set variable based on USERID

Wed, 20 Apr 2016 09:17:33 GMT

yeah, exactly, could you fix,

what should be done to get the correct line no when we login as admin

Thanks

Re: How to Trigger a set variable based on USERID

Wed, 20 Apr 2016 09:18:49 GMT

yeah, exactly.. what should be done for admin, to show up the correct line no when we login as admin

Thanks

Re: How to Trigger a set variable based on USERID

sunny_talwar — Wed, 20 Apr 2016 09:19:07 GMT

This?

=if(USERID='USER1',1,

if(USERID='USER2',2,

if(USERID='USER3',3,

If(USERID = 'RAHUL', 4))))

Re: How to Trigger a set variable based on USERID

sunny_talwar — Wed, 20 Apr 2016 09:21:01 GMT

Check now, Rahul will have LineNo 4

Re: How to Trigger a set variable based on USERID

Wed, 20 Apr 2016 09:34:24 GMT

but, i wont get any values for that , sheet, if the line no is 4, in fact there is no line no 4, in my database,,

it will be a big problem again

is there any way to get the current line no as

correspoding to that sheet

means,

when i login as admin, if the first sheet that, i see is L1, than the current line no should be 1

I hope you got me

Thanks