topic Re: How to make some variable as default select for a List Box in QlikView

How to make some variable as default select for a List Box

Wed, 11 Jun 2014 05:40:31 GMT

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.

Re: How to make some variable as default select for a List Box

ashfaq_haseeb — Wed, 11 Jun 2014 05:50:46 GMT

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

Re: How to make some variable as default select for a List Box

MayilVahanan — Wed, 11 Jun 2014 05:54:21 GMT

Try like this

Settings -> Document properties -> Triggers -> OnOpen -> Add Action

Selection -> Select in Field

Field : Userid

SearchString: = OsUser()

Re: How to make some variable as default select for a List Box

jagan — Wed, 11 Jun 2014 05:54:59 GMT

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.

Re: How to make some variable as default select for a List Box

Wed, 11 Jun 2014 06:02:07 GMT

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.

Re: How to make some variable as default select for a List Box

Wed, 11 Jun 2014 09:24:24 GMT

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.