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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

Multi_selection_boxes - hide non-applicable selections?

Hi,

I have a multi_box as a standard_element on all sheets in all my apps with selections on

- year (from a master_calendar)

- month ((from a master_calendar)

- week (from a master_calendar)

plus some others which are specific to that KPI.

I have already used the aggr() function, to show only the applicable weeks whenever any month is selected - but usually, the selection (the default one) is a year and a week, not a month. In some situations it can be helpful, though.

=> Now I wondered: Can I use a formula so that, when 2015 is selected, only the cw in the past or present (1 and 2) are shown (but when 2014 is selected, of course one would expect to have all weeks available)?

Thanks a lot!

Best regards,

DataNibbler

2 Replies
marcus_sommer

Maybe something like this in the condition:

if(YourWeekField <= week(today()) and Year = year(today()), YourWeekField)

- Marcus

Not applicable

You can hide the excluded values using the properties of the multibox object itself. See the attached snapshot.

Hope that helpsMultibox.JPG