Ignore selection in a if match expression

Anonymous — Fri, 05 Oct 2018 14:13:45 GMT

I have multiple measures that I have combined in one loaded table, but some have multiple years and some are for a fixed year.

In my table I am trying to make the data which has multiple years selectable but those which do not will be fixed and not change regardless of whether a year is selected in the multi box. I can get the data to display using the following if match statement but MeasureID 3 disappears when I select a year combination it doesn't have associated with it:

=if(match([MeasureID],1,2),sum({$<Variable={'a'}>}[Numerator]),
if(match([MeasureID],3),only({$<Variable ={'a'}>}[ Numerator])))

I tried the following to ignore the year filter, but it just makes MeasureID 3 go blank:

=if(match([MeasureID],1,2),sum({$<Variable={'a'}>}[Numerator]),
if(match([MeasureID],3),only({$<Variable ={'a'}, Year= >}[ Numerator])))

Is this possible?

Re: Ignore selection in a if match expression

sunny_talwar — Fri, 05 Oct 2018 16:07:27 GMT

May be try this

=if(Match([MeasureID], 1, 2), sum({$<Variable={'a'}>} [Numerator]),
if(Match(Only({<Year>} [MeasureID]), 3), only({$<Variable ={'a'}, Year= >} [Numerator])))

Re: Ignore selection in a if match expression

Anonymous — Mon, 08 Oct 2018 07:23:29 GMT

Thanks Sunny, this worked perfectly!

topic Ignore selection in a if match expression in QlikView

Ignore selection in a if match expression

Re: Ignore selection in a if match expression

Re: Ignore selection in a if match expression