Count text in the column

[jyothish8807]

Hi All,

I am trying to count no of entries in a column respective to different user, but QV is counting the blank entries also. how to solve this issue?

User	Entry
a	yes
a	yes
a
b	yes
b
b
c	yes
c	yes
c	yes
c
c

Now when i try to take a count using straight chart, i am getting :

a - Count (3) instead of 2.

b - Count (3) instead of 1

c - Count (5) instead of 3

When i export the data into excel and try to do it then again the same thing happens on excel sheet also.

Thanks & Regards

Jyothish KC

[bgerchikov · Accepted solution]

Hi Jyothish,

Here are a couple expressions you can use:

sum(if(len(trim(Entry))>0,1,0))

or

-1*sum(len(trim(Entry))>0)

Hope it will help

[amit_saini]

Hi KC,

Please see the attachment.

Thanks.

AS

[Anonymous]

You can even use textcount()

[jyothish8807]

Thanks a lot Boris

Regards

Jyothish KC

[jyothish8807]

Thanks a lot bro .

Regards

KC

[jsingh71]

Here is my solution:

Count

({<Entry ={yes}>}User)