Discussion Board for collaboration related to Creating Analytics for QlikView.
As a result of expression (TextCount function), wherever output is zero, two types of output is appearing in pivot table in QV.
It is either "0" (zero) or "-" (dash).
This expression is actually counting errors that are on Name of person.
What I want is if somebody has not worked on specific process, there should be "-". If no. of errors are zero, then there should be "0".
Can anybody help me to figure out problem?