Filter out in Straight table

[johnjustus]

Hi All,

I have a straight table as below in a Qlikview Document.

Name      Owner

Authorized        Keen

Un-Authorized  Steve

Late                   Keen

I don't want to show "Un-Authorized" in the straight table.

What would be the best way to filter out?

Thanks

[sunny_talwar · Accepted solution]

Use set analysis in your expression

{<Name -= {'Un-Authorized'}>}

Or calculated dimension

If(Not Match(Name, 'Un-Authorized'), Name)

and then make sure to check 'Suppress When Value Is Null' on the dimension tab

[johnjustus]

Thanks and that works

[sunny_talwar]

Great