Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
svinnakota
Creator
Creator

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
Master III
Master III

if you want to show only ABC try like this

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

jonathandienst
Partner - Champion III
Partner - Champion III

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'

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
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');