Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

Ignore Year Filter in Multibox

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!

1 Solution

Accepted Solutions
MVP
MVP

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

=Max({1} Year)

View solution in original post

6 Replies
Partner
Partner

Hi,

Does this work?

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

Partner
Partner

No.. It is not giving me any value

Creator III
Creator III

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.

Partner
Partner

Uploaded the sample file

MVP
MVP

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

=Max({1} Year)

View solution in original post

Partner
Partner

Great... It worked.

Thank You so much !!