Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Expression result

Hi,

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?

Community Browser