topic Multi_selection_boxes - hide non-applicable selections? in QlikView

Multi_selection_boxes - hide non-applicable selections?

datanibbler — Wed, 07 Jan 2015 14:13:22 GMT

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

Re: Multi_selection_boxes - hide non-applicable selections?

marcus_sommer — Wed, 07 Jan 2015 14:20:11 GMT

Maybe something like this in the condition:

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

- Marcus

Re: Multi_selection_boxes - hide non-applicable selections?

Wed, 07 Jan 2015 14:28:57 GMT

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

Hope that helps