Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-05-16 08:52 AM

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?

289 Views
0 Likes
0 Replies