Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count Issue

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

5 Replies
MayilVahanan

Hi,

     Try this,

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

     Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

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

Not applicable
Author

Single expression only in this straight table

Not applicable
Author

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

CELAMBARASAN
Partner - Champion
Partner - Champion

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