topic Re: Multiple Count Functional in QlikView

Multiple Count Functional

Mon, 06 Oct 2014 08:05:13 GMT

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 — Mon, 06 Oct 2014 08:14:09 GMT

Set NullInterpret = '';

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

Reviewer1,Reviewer2,Reviewer3,Reviewer4

John Martin ,,Grace Willer,Spencer James ];

Mon, 06 Oct 2014 08:30:45 GMT

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 — Mon, 06 Oct 2014 08:35:49 GMT

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 — Mon, 06 Oct 2014 08:46:06 GMT

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

Can you attach sample qvw

Mon, 06 Oct 2014 09:01:31 GMT

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 — Mon, 06 Oct 2014 09:11:43 GMT

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

Mon, 06 Oct 2014 09:25:37 GMT

Thanks a lot!