Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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')
Hi Yelin,
Select the month of December, va on properties on the General tab and check the option:
Always one selected value
best regards
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...
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
Hi,
Use the trigger Select in Field after you do "Clear All" action is performed.
See the attachment.
You can apply the december month on a trigger Select in field when Clear All action is applied.
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.
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')
Hi,
Please find attached file for solution.
Regards,
Jagan.