Exclude Value(s) From Dimension

[#1]

Hi

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

[whiteline]

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

[#3]

Hi

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

[#4]

Hi

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

[whiteline · Accepted solution]

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

[#6]

Hi

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

Cheers

Geoff

[felcar2013]

hi

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