Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

svinnakota
Contributor

Except Condition in Qlik sense

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

3 Replies
arulsettu
Honored Contributor III

Re: Except Condition in Qlik sense

if you want to show only ABC try like this

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

MVP
MVP

Re: Except Condition in Qlik sense

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'

MVP
MVP

Re: Except Condition in Qlik sense

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');