topic Re: Default View - List Box in QlikView

Default View - List Box

Wed, 25 Nov 2020 16:16:04 GMT

I would like to know how to set default selection in a list box whenever a sheet is opened.

for e.g., my list box has following values - Alpha, Beta, Gamma. Whenever I open my sheet with this list box I want , 'Alpha' to be selected by default.

Is this possible ?

Re: Default View - List Box

trdandamudi — Tue, 16 May 2017 01:20:33 GMT

Yes it is possible... Please follow below steps:

Click on Settings

Select Document properties

Click on 'Triggeres' tab

Select 'OnOpen' from Document Event Triggers

Click on Add Action

Select 'Select in field' under Actions

In the field type your fieldname (Example: Type)

in the Search String box type Alpha

Click Ok.

Hope this helps..

Re: Default View - List Box

Akina0929 — Tue, 16 May 2017 11:29:12 GMT

Hi Akanksha,

select one value in list box and open properties of list box in general check Always one selected value. !

Re: Default View - List Box

Anonymous — Tue, 16 May 2017 12:57:27 GMT

Yes, it is possible.

On List box select " Alpha " ---> Right Click ----> Properties--->General Tab--->Enable " Always One Selected Value " ---> Ok

Whenever you open qv application by default it will make selection on " Alpha "

Hope it helps!!

Re: Default View - List Box

Anonymous — Tue, 16 May 2017 13:10:24 GMT

Or else

If you want for particular sheet then follow like this

Right Click on Sheet--->Sheet Properties---->OnActivate Sheet--->Click on Add Action--->Add--->Action Type-

" Selection "--->Action- "Select in Field"--->Click Ok--->Field - Enter " Field Name " ---> Search String - Enter " Alpha "---> Ok--->Ok

Now whenever you open or move to this sheet by default, list box value " Alpha " will be selected.

Hope it helps!!

Re: Default View - List Box

Tue, 16 May 2017 20:33:27 GMT

Thank you, it worked

Re: Default View - List Box

Tue, 16 May 2017 20:34:42 GMT

Thank you for your responses.

Re: Default View - List Box

vishsaggi — Tue, 16 May 2017 20:54:25 GMT

Hello Priya,

If it answered your question can you close the thread by selecting one answer as correct and any other you think are helpful.

Re: Default View - List Box

Anonymous — Wed, 17 May 2017 03:56:58 GMT

Glad to Help!!