topic default selection in QlikView

default selection

yelin_nyu — Sun, 20 Oct 2013 22:07:39 GMT

Assume I have a field ‘MonthName’ with values Jan, Feb, Mar…Dec.

I want a List box where the user can select one or more
MonthName … but I need Dec to always be selected (even when ‘Clear’ is hit)

Any ideas?

Re: default selection

Mon, 21 Oct 2013 01:56:49 GMT

Hi Yelin,

Select the month of December, va on properties on the General tab and check the option:

Always one selected value

best regards

Re: default selection

amars — Mon, 21 Oct 2013 03:09:10 GMT

Hi Yelin,

Refer to the below link (http://qlikshare.com/856)

It should help you identify ClearAll event. On ClearAll you can put one more action to select the Dec Month.

Thanks...

Re: default selection

Mon, 21 Oct 2013 05:46:54 GMT

Hi Yelin,

What do u really want to achieve? There may be some other work around, but for that you have to explain more in detail what you actually need.

Below are some of the possibilities that you need

1. Set analysis in expression for month of Dec

2. Some action triggers in the sheet property

3. or a macro

Re: default selection

Mon, 21 Oct 2013 06:08:19 GMT

Hi,

Use the trigger Select in Field after you do "Clear All" action is performed.

See the attachment.

Re: default selection

Mon, 21 Oct 2013 06:24:36 GMT

You can apply the december month on a trigger Select in field when Clear All action is applied.

Re: default selection

yelin_nyu — Mon, 21 Oct 2013 13:37:55 GMT

I need a LED/checkbox lixt of the 12 months and Dec is always selected, even if they select other months/unselect them.

If I select Jan and Mar, my final outcome is Jan, Mar, and Dec.

Re: default selection

MayilVahanan — Mon, 21 Oct 2013 13:49:09 GMT

Try like this

Document Properties -> Trigger -> Field Event Triggers: Month -> OnSelect -> Select in Field

Field:

Month:

Search String

=If(GetSelectedCount(Month) > 0, '(*'&GetFieldSelections(Month,'*|*')&'*|*Dec*)' , 'Dec')

Re: Re: default selection

jagan — Mon, 21 Oct 2013 14:18:11 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.