Qlikview table - Don't show the line if columns project name is equal "-"...

[#1]

Hi, i have a table with the following columns:

- dimension: project area

- dimension: project name

- expression: =sum(totalhours)

Some of the projects has the name equal "-'. i don't want to show the entire line nor include this at the table sum when the project name has this name. Is there someway to exclude these lines?

Oscar

[disqr_rm · Accepted solution]

QlikView will also show - for a null value. If it is null value, you can use "Suppress When when is null" checkbox under dimension. If you really got project names as "-" then you could do calculated dimension as if(ProjectName <> '-', ProjectName) and use the Suppress Null checkbox.

Hope this helps.