Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
yelin_nyu
Contributor

default selection

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?

1 Solution

Accepted Solutions
Highlighted

Re: default selection

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

View solution in original post

8 Replies
Highlighted
Not applicable

Re: default selection

Hi Yelin,

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

Always one selected value

best regards

Highlighted
amars
Valued Contributor

Re: default selection

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

Highlighted
Not applicable

Re: default selection

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


Highlighted
Not applicable

Re: default selection

Hi,

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

See the attachment.

Highlighted
Not applicable

Re: default selection

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

Highlighted
yelin_nyu
Contributor

Re: default selection

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.

Highlighted

Re: default selection

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

View solution in original post

Highlighted
MVP & Luminary
MVP & Luminary

Re: Re: default selection

Hi,

Please find attached file for solution.

Regards,

Jagan.