Ignore Year Filter in Multibox

[amruta_j]

Hi all,

I need to show Reporting Period for current year only irrespective of Year filter.

Means If I select Year as 2017, my Reporting Period should show 2018 only.

I'm using below expression in Reporting Period Listbox:

=if([Reporting Year]=$(vCurrYear),[Reporting Month])

Alternate state won't work here.Can you please help me?

Thanks!

[niclaz79]

Hi,

Does this work?

Only({<[Reporting Year] = $(vCurrYear)>}[Reporting Month])

[amruta_j]

No.. It is not giving me any value

[jensmunnichs]

Can you share your data model and the definition of vCurrYear (or even better, your qvw file or part of it)?

I'm not entirely sure which part of it isn't working, but I can imagine that, depending on your data model, things go wrong when you select a year. For example, you might get your Reporting Month listbox to show the right values, but they might all be excluded because of the year you've selected. If you then try to select any of the reporting months, it'll deselect the year, and you'll be back to square 1.

Again, it'd be easier to identify the problem if you could share your file.

[amruta_j]

Uploaded the sample file

[tresesco · Accepted solution]

What if you ignore selections including {1} in vCurrYear variable definition like:

=Max({1} Year)

[amruta_j]

Great... It worked.

Thank You so much !!