Excluding some values

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a question concerning the exclusion of some values.

I have a dimension Year= 1998, 2013, 2014, 2015, 2016

And I have the dimension Month= jan ... dec.

When I create my report, I select the current month and year. A couple of my tables only show he results for that specific month and year. One of my tables however is a chart with all months visbible, so I use Month= in my expression. That's that.

But I also want multiple years visible. This is where the issue lies: I only want 2014, 2015 and 2016.

Problem is, to create my report, I selected '2016' and I cannot write Year= because that would also show me results for 1998 and 2013 in this specific chart (and I do not want those years being visible).

I tried to use the combination of both Year= in my expression and a calculated dimension saying =if(Year='2014' OR '2015' OR '2016', Year) but that does not work unfortunately, it still shows me all of the values for Year. Apparently an expression is 'stronger' dan a calculated dimension.

How can I solve this issue?

Thanks in advance!

Re: Excluding some values

Chanty4u — Wed, 16 Mar 2016 08:43:57 GMT

chk below

Excluding values in Set Analysis

Re: Excluding some values

ali_hijazi — Wed, 16 Mar 2016 08:49:01 GMT

if your expression is Sum(Sales) then to exclude the year 1998 you write the following:

sum(${<Year={'*'}>-<Year={1998}>} Sales)

* means all years (Nulls are excluded)

you can write sum({<Year -={1998}>}Sales)

Re: Excluding some values

Wed, 16 Mar 2016 10:56:15 GMT

Thanks for the link!

Using = - {} instead of - = {} did the trick!

topic Re: Excluding some values in QlikView

Excluding some values

Re: Excluding some values

Re: Excluding some values

Re: Excluding some values