How to Trigger a set variable based on USERID

[#1]

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

[sunny_talwar · Accepted solution]

See if the attached file solves all the issues

[#3]

gr8 sir,, yeah

that will be gr8,

than each will get the line no by using sheet trigger ,, this should work fine

Thank you

[sunny_talwar]

Awesome

[#5]

may i ask you, why it started working after entering the user id in capitols, is it because, QV takes the usernames in capitals??

[sunny_talwar]

In your script you are loading USERID as Upper(USERID) which makes USERID field to be all upper case. And QlikView is case sensitive and hence you need to use the correct casing

[Chanty4u]

yes  Qlikview is case sensitive  And Qlikview functions are not case sensitive

[#8]

Hi kaushik,

I tried with Qvuser also, its also working

so we can use the Qvuser() instead of any userid column we have mentioned in section access table is it?

Thanks

[#9]

i checked it, its also working

Thanks

[#10]

Thanks

[#11]

Thanks