Except Condition in Qlik sense

[svinnakota]

Hi All,

I need to get only the specific values in a column and remaining values should not be shown in the field or filter.

For Example: I am having Name as field.

Name

A

B

C

D

Now i want to display only the ABC values but not the D value in the name field or it can be greyed.

Can anyone help me in solving this puzzle...

Thanks,

Santosh

[arulsettu]

if you want to show only ABC try like this

if match(Name,'A','B','C')

[jonathandienst]

You could use a calculated dimension:

=If(Name <> 'D', Name)

Or set expression in the chart/table expression:

{<Name -= {'D'}>}

To filter the chart or table to exclude 'D'

[sunny_talwar]

Not sure if this is needed during the reload or on the front end.

For during reload, you can try Where Not Match(...);

LOAD Name

FROM ....

Where not Match(Name, 'D');