topic Re: Exclude value from dimention in QlikView

Exclude value from dimention

alec1982 — Wed, 20 Jun 2012 16:50:42 GMT

Hi,

How can I exclude a value from showing up in dimension

like the dimension in my case is Year([Fieldname])

And the field shows 2012 2013 2014 2015

I would like to exclude 2012.

Thxs,

erichshiino — Wed, 20 Jun 2012 17:01:17 GMT

Hi, Alec.

Are you using this dimension in a list or in a chart?

You can change your it a little bit to exclude 2012.

For example, instead of Year([Fieldname]), you can use:

= if ( Year([Fieldname]) > 2012, Year([Fieldname]) )

= if ( Year([Fieldname]) > year(today()), Year([Fieldname]) )

In a listbox, the result will 2013, 2014...

In a chart, 2012 results will be a in a line where Year is NULL.

You can hide this by checking the option 'Hide when value is null' on the dimension tab of your chart.

... you can also create a Year field, instead of using Year([Fieldname]) in your charts. this might increase the performance a little bit.

hope this helps,

Erich

alec1982 — Wed, 20 Jun 2012 17:05:55 GMT

If(Year([Fieldname]) <> '2012', Year([Fieldname]))