Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a field named as USERID.
I am using this in a List box.
I want to make the default select of this ListBox as OSUser() value.
How can I perform this ???
Thanking in advance.
Hi all,
Thanks for your answers.
I tried to use the Sheet Trigger and it worked.
I believe, this way, it won't create any further issues.
Thanks again for your precious advises.
Hi
I believe for this you have to use section access.
It depends on the data you have.
Can you post sample application to help you out?
Regards
ASHFAQ
Hi
Try like this
Settings -> Document properties -> Triggers -> OnOpen -> Add Action
Selection -> Select in Field
Field : Userid
SearchString: = OsUser()
Hi,
Try like this
Settings -> Document Properties -> Triggers -> On Open -> Add Action -> Add -> Select -> Select in Field ->
In Field give your field name and in Search String give =OSUser()
This sets the OSUser() value as selected value in the field on opening the Qlikview Document.
If you on activating the Sheet then try like this
Sheet Properties -> Triggers -> On Activate Sheet -> Add Action -> Add -> Select -> Select in Field ->
In Field give your field name and in Search String give =OSUser()
This sets the OSUser() value as selected value in the field on activating the sheet.
Hope this helps you.
Regards,
Jagan.
Hi Mayil,Jagan
I tried to use the same. but when I am accessing the document from web server, it is not triggering the OnOpenDocument event. Because of this, the value is not getting selected.
Hi Ashfaq,
I cannot use the section access because of 2nd time authentication process.
Every time , the user tries to open the document, it will ask the user to authenticate,
I have to use the same authentication, which Qlikview has already done( as a form of CAL).
Now I hope, things will be more clear for you to help me.
Thanking in advance.
Hi all,
Thanks for your answers.
I tried to use the Sheet Trigger and it worked.
I believe, this way, it won't create any further issues.
Thanks again for your precious advises.