topic Re: Default Selection for list box in QlikView

Default Selection for list box

manideep78 — Thu, 23 Jan 2014 16:02:24 GMT

Hi All

How can I select all values in list box by default.??

If I select any value in the list box that particular value needs to be selected but If I uncheck the selected option, all values should be selected by default.

any help will be appreciated

Regards,

Manideep

Re: Default Selection for list box

Nicole-Smith — Thu, 23 Jan 2014 16:07:44 GMT

Let's say you wanted to add this functionality to your field Date. You would do so by adding a trigger to the field like the following:

Example file also attached.

Re: Default Selection for list box

Thu, 23 Jan 2014 16:09:59 GMT

wouldn't it be simplier to set an action with

Select all possible values for the field ?

Best regards

Chris

Re: Default Selection for list box

Nicole-Smith — Thu, 23 Jan 2014 16:11:25 GMT

christian juillard -- You're right. Much simpler. I completely missed out on that one

Re: Default Selection for list box

manideep78 — Thu, 23 Jan 2014 16:14:31 GMT

Thanks Smith

Regards,

Manideep

Re: Default Selection for list box

manideep78 — Thu, 23 Jan 2014 16:21:37 GMT

christian juillard - Could you please tell me how it will work? I already implemented that action with the help of button but could get the result.

Re: Default Selection for list box

Nicole-Smith — Thu, 23 Jan 2014 16:25:10 GMT

Manideep,

It works the same as my example except where I have the "Select in Field" action, you would put "Select Possible" instead.

Re: Re: Default Selection for list box

Thu, 23 Jan 2014 16:26:10 GMT

Here it is

check Sheet properties

chris

Re: Default Selection for list box

manideep78 — Fri, 24 Jan 2014 08:43:38 GMT

christian juillard - In your application it gives me the values only I selected. Let me tell you in clear with an example.

Suppose if I have a list box year in which 2004,2005 and 2006 exists. If I select 2004 it will be marked as selected and If I select 2004 and 2005 they both will be selected but I unselect 2004, then all values should be selected. This is not working with your example using Select possible action.

I got this through Nicole Smith example. But here my problem is I having special symbols along with year in year list box. I could not achive this with both examples.

Could you please help me how can I do this?

Regards

Manideep

Re: Default Selection for list box

Fri, 24 Jan 2014 09:51:26 GMT

So if you want the oppositie, use Select excluded values

best regards

Chris

Re: Default Selection for list box

Nicole-Smith — Fri, 24 Jan 2014 13:59:29 GMT

What do you mean by special symbols? Can you tell me what the values are/look like?