topic Re: Exclude Value(s) From Dimension in QlikView

Exclude Value(s) From Dimension

Thu, 30 Aug 2012 10:51:04 GMT

I have a bar chart based on one field that contains a default value that has no meaning in the chart but is needed elsewhere in the model. How can I exclude it? I've tried using <> 'textValue' as a calculated dimension with no joy ... Do I need to create a separate field in the load script?

Cheers

Geoff

Re: Exclude Value(s) From Dimension

whiteline — Thu, 30 Aug 2012 11:06:52 GMT

=aggr(if([YourDimension]<>'UndesieredValue', [YourDimension], null(), [YourDimension])

Re: Exclude Value(s) From Dimension

Thu, 30 Aug 2012 11:22:09 GMT

Don't think I need the aggr but sorting the syntax to give me:

= If([cConsultant] <>'H9999999',[cConsultant], null())

Seems to do the trick.

Many thanks.

Geoff

Re: Exclude Value(s) From Dimension

Thu, 30 Aug 2012 11:22:20 GMT

Don't think I need the aggr but sorting the syntax to give me:

= If([cConsultant] <>'H9999999',[cConsultant], null())

Seems to do the trick.

Many thanks.

Geoff

Re: Exclude Value(s) From Dimension

whiteline — Thu, 30 Aug 2012 11:23:59 GMT

It depends on version of QlikView that you're using.

Re: Exclude Value(s) From Dimension

Thu, 30 Aug 2012 11:26:00 GMT

Ah... Using V11.0 SR1, thanks again.

Cheers

Geoff

Re: Exclude Value(s) From Dimension

felcar2013 — Fri, 07 Jun 2013 15:57:40 GMT

if we have a list of values? i tried with "or" or just "commas", did not work.