Multiple Count Functional

[#1]

Hi QlikViewers

I want to perform a count funtion for multiple fields and only get the result in one field

e.g Reviewer1,   Reviewer2,      Reviewer3,         Reviewer4

     John Martin             -          Grace Willer         Spencer James

I want the Count result to be [All Reviewer]= 3

How can I do this?

[anbu1984]

Set NullInterpret = '';

Load *,RangeCount(Reviewer1,Reviewer2,Reviewer3,Reviewer4) Inline [

Reviewer1,Reviewer2,Reviewer3,Reviewer4

John Martin ,,Grace Willer,Spencer James ];

[#3]

Hi Anbu

Thanks for your answer. I have tried your solution but it doesn't return the correct answer though. It returns the value of "4" instead of "3"

[preminqlik]

in front end you can do like this

rangesum(count(reviewer1),0)+rangesum(count(reviewer2),0)+rangesum(count(reviewer3),0)+rangesum(count(reviewer4),0)

or in backend

you need to do cross table and then you need to count i think.

[anbu1984 · Accepted solution]

Did you add Set NullInterpret = ''; in your script?

Can you attach sample qvw

[#6]

Hi Anbu

Thanks! I didn't add the Set NullInterpret = ''; in the script. It works now.

If you don't mind can you please explain to me how this logic works? It's the first time I'm seeing this awesome fuction.

[anbu1984]

From QV Help

rangecount(expr1 [ , expr2, ... exprN ])

Returns the number of values found within a range of 1 to N arguments. NULL values are not counted.

Set NullInterpret = ''; -- This will convert all blank fields to NULLs

[#8]

Thanks a lot!