topic Re: sheet triggers in QlikView

sheet triggers

Tue, 31 Jul 2012 10:49:28 GMT

How to make sure that when we open the document or sheet, One particular value from the listbox is selected by default?

Listbox name is 'Names' and value want to be selected on opening is 'John'.........

Re: sheet triggers

daveamz — Tue, 31 Jul 2012 11:21:04 GMT

Hi,

Try Settings > Document Properties > On Open > Add Action > Add > Selection > Select in Field

For 'Field' fill in with the fieldname and for 'Search String' fill in the field value you want to be selected on opening.

Re: sheet triggers

Tue, 31 Jul 2012 11:30:09 GMT

thanks for the reply, the current selection box is showing that 'john' has been selected, but on the basis of this selection, my charts are not getting refreshed. what should i do so that when i open the document, 'john' should be selected and my charts should be refreshed based on my default slection.

Re: sheet triggers

jonathandienst — Tue, 31 Jul 2012 12:02:25 GMT

If the charts are not "refreshed", then they are not dependant on the fields being selected in the trigger, or the chart expressions use set analysis that overrides the selection in that field.

Regards

Jonathan