Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

MultiBox Excluded values


Hi,

i have a multibox in my layout like YEAR, MONTH

under YEAR having 2013 & 2014.

MONTH for 2013 year i have limited months only and 2014 i have Jan to Dec.

my issue is if i selected 2013 in multibox YEAR field, i want to display only 2013 included values.

how can i do this please Help me

Kindly Regards

1 Solution

Accepted Solutions
flipside
Partner - Specialist II
Partner - Specialist II

The Hide Excluded option for MultiBox objects is on the Properties tab. You need to select the Field in the left pane, then tick the box in the right pane.

flipside

View solution in original post

5 Replies
ecolomer
Master II
Master II

One option is chech in the month list option to no show non selectable values

Not applicable
Author

Hi Enrique Colomer,

Thank you for your solution, actually which you have gave me is the list box example, i knew that one.

But i want the same in multi box dropdown list

Not applicable
Author

Edit the month field in multi box and use this

=Aggr(only({<Month=P(Month)>}Month),Month)

flipside
Partner - Specialist II
Partner - Specialist II

The Hide Excluded option for MultiBox objects is on the Properties tab. You need to select the Field in the left pane, then tick the box in the right pane.

flipside

Not applicable
Author

Thank You for your help