Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks and that works
Great