topic Re: Always one Selected value in QlikView

Always one Selected value

surajap123 — Thu, 16 Oct 2014 08:57:53 GMT

Hi Experts,

I want to a specific value(Say 5) to be always selected(by default) in the list box when i open the application.

The issue is, the selected value(default) changes based on the last saved value in that list box.

Can i write some expression to force a specific value(5) to be always selected in the list box??

Re: Always one Selected value

alexandros17 — Thu, 16 Oct 2014 09:02:04 GMT

If that value doesn't exsist in data you cannot but you can force that value in your data for any week you want simply using load inline

Let me know

Re: Always one Selected value

ashfaq_haseeb — Thu, 16 Oct 2014 09:02:40 GMT

Hi,

Add trigger on open to select value 5 in ID field.

have a look at attached document

Regards

ASHFAQ

Re: Always one Selected value

martinpohl — Thu, 16 Oct 2014 09:04:03 GMT

have a look at document properties / triggers / on open / select in field

remember: this action is not started in AJAX

See help:

OnOpen

Select this event to assign an action to be executed each time the QlikView document is opened. This event is not supported when running in the AJAX client.

Regards

Re: Always one Selected value

suresh_rawat — Thu, 16 Oct 2014 09:10:45 GMT

Hi,

Yes you can fix a value to show when you open the application.

Just use triggere -> Select in Field -> Field is as ID - >Serch String - > 5(As per your requirement).

For reference please go thorough the application as attached.

Re: Always one Selected value

MarcoWedel — Thu, 16 Oct 2014 10:16:19 GMT

Hi,

in order to dynamically select e.g. the max value in this listbox, you could use expressions in the search string of the select in field action of the application's OnOpen trigger:

hope this helps

regards

Marco