topic Re: Filter out in Straight table in QlikView

Filter out in Straight table

johnjustus — Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 12 May 2017 17:56:48 GMT

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 — Fri, 12 May 2017 18:21:32 GMT

Thanks and that works

sunny_talwar — Fri, 12 May 2017 18:22:03 GMT

Great