Discussion Board for collaboration related to Creating Analytics for QlikView.
Does anyone know how to only show the dimesion rows where a columns results are greater than zero, thanks.
Here is some code im using in the "Add Calculated Dimension" box of the Dimensions tab.
=IF([ColumnName] > 0, ETMSpecialty)
Go to Solution.
Try to use column Expression insted of [ColumnName].
Also rewrite your expression like this:
=aggr(IF((ColumnExpression) > 0, ETMSpecialty), ETMSpecialty)
Another option go for same query and check mark on "Suppress where value is null".
For your reference find the attached application.
I'll Try this thanks
This worked with the suppress where value is null...
thanks my friends