topic List Box with default selection in QlikView

List Box with default selection

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have created a List box with a multi selection possibilities and i have following Values:

- Value 1

- Value 2

- Value 3

- Value 4

- Value 5

- No Information.

Now i want to have " No Information" selected as default (When document loads and on Clear)

and also when i select any other value (incl. Multi select) the "No Information" needs to be selected all time.

Is this possible?

THX

Re: List Box with default selection

ecolomer — Mon, 29 Aug 2016 19:38:08 GMT

You can assign a trigger to field in order to select a value at start and also more trigeer when select another value

Sorry because my english isn't good

If you nedd I can write an example

Re: List Box with default selection

Clever_Anjos — Mon, 29 Aug 2016 19:42:59 GMT

Pre-select "No Information"
Use Set Clear State

Re: List Box with default selection

Mon, 29 Aug 2016 20:07:18 GMT

Enrique,

Thanks for your response, but i didn't completely understand your answer.

can you please give an example?

Re: List Box with default selection

Mon, 29 Aug 2016 20:10:15 GMT

Clever,

i tried using Clear State as you said,but it didn't work 😕

Re: List Box with default selection

rupamjyotidas — Mon, 29 Aug 2016 20:37:49 GMT

What Enrique was trying to say is that you should apply Triggers for the same. 'On AnySelect' should work

Re: List Box with default selection

Anil_Babu_Samineni — Tue, 30 Aug 2016 02:41:36 GMT

Have you tried this option. First select whatever value you required. Then, goto listbox properties and check always select one value then save. And close it and then open and try to clear. Might be you will reach the target.

Re: List Box with default selection

tamilarasu — Tue, 30 Aug 2016 03:26:18 GMT

Hi Shani Damri,

You can try below expression

='("No Information"' & If(GetSelectedCount(Value) > 0, '|' & Chr(34) & GetFieldSelections(Value, Chr(34) & '|' & Chr(34)) & Chr(34)) & ')'

I have attached a sample document and trigger action screen shot for better understanding!!

Have a nice day.

Re: List Box with default selection

ecolomer — Tue, 30 Aug 2016 03:39:20 GMT

Here you have an example

Re: List Box with default selection

Clever_Anjos — Tue, 30 Aug 2016 11:23:06 GMT

It´s supposed to work.

Please find attached

Re: List Box with default selection

Thu, 01 Sep 2016 10:57:03 GMT

Thank you all!!!

Re: List Box with default selection

Anonymous — Mon, 13 Nov 2017 18:25:57 GMT

Hi Clever,

I realized your reply was more than a year ago but I'm new to QV and have been looking in your

sample "230770.qvw" this morning. I looked in Settings -> Document Properties -> Trigger and I am not seeing

where you coded and placed logic to handle the default. Can you tell how you did this?

Re: List Box with default selection

Clever_Anjos — Tue, 14 Nov 2017 19:20:37 GMT

I don´t use triggers,

I´ve used the Clear State configuration as this screenshot

Re: List Box with default selection

Anonymous — Tue, 14 Nov 2017 19:46:42 GMT

ok, thanks for responding.