default selection

[yelin_nyu]

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?

[#2]

Hi Yelin,

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

Always one selected value

best regards

[amars]

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...

[#4]

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

[#5]

Hi,

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

See the attachment.

[#6]

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

[yelin_nyu]

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.

[MayilVahanan · Accepted solution]

Hi

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')

[jagan]

Hi,

Please find attached file for solution.

Regards,

Jagan.