topic Re: Count Issue in QlikView

Count Issue

Thu, 12 Jul 2012 17:10:40 GMT

I have a count set up to count the amount of users within a 'Group' field. So I set up a straight table with dimension of 'Group' and then an expression of

'Count(Username)'.

I was interested to find out that some of the groups have no usernames in them, however, they are not showing up in my straight table.

Is there a different way I need to do the count?

I already went into the straight table settings and unmarked the 'Surpress Zero values'.

Any help would be great. I can not post a sample.

Thanks

Re: Count Issue

MayilVahanan — Thu, 12 Jul 2012 17:22:39 GMT

Hi,

Try this,

=If(Count(UserName) = 0, NullCount(UserName), Count(UserName))

Hope it helps

Re: Count Issue

CELAMBARASAN — Thu, 12 Jul 2012 17:43:23 GMT

Hi,

Do u ve any other expression with it?or ur using single expression only in this straight table?

Re: Count Issue

Thu, 12 Jul 2012 18:01:15 GMT

Single expression only in this straight table

Re: Count Issue

Thu, 12 Jul 2012 18:32:22 GMT

You can add one more expression which always returns some non-null value for any group, e.g.

count(Group)

then hide it on tab Chart Properties -> Presentation

Re: Count Issue

CELAMBARASAN — Thu, 12 Jul 2012 19:43:42 GMT

Try by checking the Show All values option in the Dimension tab