topic Re: Default value set on Listbox and Calendar Object in QlikView

Default value set on Listbox and Calendar Object

vipingarg23 — Mon, 28 Aug 2017 17:10:48 GMT

Hi Team,

I have one listbox object and one calendar object. I want that when I open qvw file, default value should be selected for both object.

I am applying trigger but it is not working.

For listbox:

Sheet Properties->Triggers->OnActiveSheet->Select in field...

field = name of field

search string=value(I need to search SEPT)

I am doing same for calendar object also but it is not working for both.

Re: Default value set on Listbox and Calendar Object

sunny_talwar — Mon, 28 Aug 2017 17:14:59 GMT

Would you be able to share a sample qvw where you might have tried this to see what might be an issue?

Re: Default value set on Listbox and Calendar Object

vipingarg23 — Mon, 28 Aug 2017 17:49:40 GMT

Please find the attachment for listbox. I need JAN as default selected value. I have applied trigger which is not working

Re: Default value set on Listbox and Calendar Object

mayankraoka — Mon, 28 Aug 2017 18:06:37 GMT

Hi Vipin,

This can be achieved by using on open trigger.

PFA application.

Regards,

Mayank

Re: Default value set on Listbox and Calendar Object

mayankraoka — Mon, 28 Aug 2017 18:08:56 GMT

On activate sheet will work if you move from main sheet to Sheet1.

The other way for this could be save the application by default selections you want.

Regards,

Mayank

Re: Default value set on Listbox and Calendar Object

sunny_talwar — Mon, 28 Aug 2017 18:19:15 GMT

I don't see any triggers... did you attach the right file? Also, do you always want JAN to be selected? or this can change based on another condition?

Re: Default value set on Listbox and Calendar Object

sunny_talwar — Mon, 28 Aug 2017 18:20:52 GMT

My bad, I see it now.... You need to remove the = sign from your field name

Re: Default value set on Listbox and Calendar Object

vipingarg23 — Mon, 28 Aug 2017 18:23:28 GMT

Yes..Right, it is working in this example. But I am not sure why it is not working in my application once I am applying the same.

Re: Default value set on Listbox and Calendar Object

vipingarg23 — Mon, 28 Aug 2017 18:26:16 GMT

Good catch Sunny...I was again doing the same mistake. Now it is working fine after removing = sign. Thanks Sunny and Mayank for the help.

Re: Default value set on Listbox and Calendar Object

vipingarg23 — Mon, 28 Aug 2017 18:31:11 GMT

Can anyone help me for calendar object also.

Re: Default value set on Listbox and Calendar Object

sunny_talwar — Mon, 28 Aug 2017 18:34:10 GMT

What is the issue with Calendar object?

Re: Default value set on Listbox and Calendar Object

vipingarg23 — Mon, 28 Aug 2017 18:39:35 GMT

I need to set a default selection (like listbox) of date as current date in calendar object. but in calendar object I am using field not variable. So I need to implement this without variable.

Re: Default value set on Listbox and Calendar Object

sunny_talwar — Mon, 28 Aug 2017 18:41:12 GMT

Can you add this to your above document for us to take a look at?