topic Re: Ignore Year Filter in Multibox in QlikView

Ignore Year Filter in Multibox

amruta_j — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Ignore Year Filter in Multibox

niclaz79 — Tue, 09 Oct 2018 06:48:40 GMT

Hi,

Does this work?

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

Re: Ignore Year Filter in Multibox

amruta_j — Tue, 09 Oct 2018 07:00:08 GMT

No.. It is not giving me any value

Re: Ignore Year Filter in Multibox

jensmunnichs — Tue, 09 Oct 2018 08:05:34 GMT

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.

Re: Ignore Year Filter in Multibox

amruta_j — Tue, 09 Oct 2018 08:35:38 GMT

Uploaded the sample file

Re: Ignore Year Filter in Multibox

tresB — Tue, 09 Oct 2018 08:59:11 GMT

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

=Max({1} Year)

Re: Ignore Year Filter in Multibox

amruta_j — Tue, 09 Oct 2018 09:08:39 GMT

Great... It worked.

Thank You so much !!