topic Count text in the column in QlikView

Count text in the column

jyothish8807 — Wed, 19 Mar 2014 03:32:03 GMT

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?

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 — Wed, 19 Mar 2014 03:48:18 GMT

Hi Jyothish,

Here are a couple expressions you can use:

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

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

Hope it will help

amit_saini — Wed, 19 Mar 2014 04:38:29 GMT

Hi KC,

Please see the attachment.

Thanks.

Anonymous — Wed, 19 Mar 2014 04:44:26 GMT

You can even use textcount()

jyothish8807 — Wed, 19 Mar 2014 04:47:32 GMT

Thanks a lot Boris

Regards

Jyothish KC

jyothish8807 — Wed, 19 Mar 2014 04:48:45 GMT

Thanks a lot bro .

Regards

jsingh71 — Wed, 19 Mar 2014 04:57:15 GMT

Here is my solution:

Count

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