topic Re: How can i count empty/blank string values in a expression ? in QlikView

How can i count empty/blank string values in a expression ?

Wed, 19 Aug 2015 14:10:34 GMT

Hello

How can i count empty/blank string values in a expression ?

Wed, 19 Aug 2015 14:14:51 GMT

try
=Count(Null())

=Sum(Null())

sinanozdemir — Wed, 19 Aug 2015 14:18:28 GMT

Maybe try something like this:

For empty/blank values = Count({<[Your Dimension Name] = {''}>} [Your Dimension Name])

For null values = Count({1 - <[Your Dimension Name] = {"*"}>} [Your Dimension Name])

Wed, 19 Aug 2015 14:19:19 GMT

that doesnt work

I have already the count of actual NULL value by using NullCount(ProductModel)

But, now i want to count the empty string fields inside ProductModel , how can i do that ?

Wed, 19 Aug 2015 14:21:39 GMT

= Count({<[ProductModel] = {''}>} [ProductModel])

= Sum( {$<ProductModel = {''}>} ProductModel )

Anonymous — Wed, 19 Aug 2015 14:23:56 GMT

hi akintosh,

try as below:

In script:

load *,
if(LEN(TRIM(FieldName)) = 0,'1','0') Flag
From ......;

In expression:

count({< Flag = {1}>}FieldName)

sinanozdemir — Wed, 19 Aug 2015 14:24:12 GMT

Please see my original answer.

Wed, 19 Aug 2015 15:26:23 GMT

worked perfectly, thanks!

sinanozdemir — Wed, 19 Aug 2015 15:34:34 GMT

You are welcome.