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?
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.