topic Re: Counting Multiple Values in QlikView

Counting Multiple Values

Sat, 25 Jan 2014 13:41:29 GMT

I'm trying to write an expression which i can't seem to get to work, Its for a text Object, Please could someone advise what im doing wrong? Problem ID is a column of call reference numbers, and i just want to count all the calls with Open and Project Status? however when use the below it counts everything including calls with a status of Closed.

=Count( if(Status ='Open','Project',([Problem ID])) )

Any Help would be greatly appreciated

Thanks

Paul

Re: Counting Multiple Values

swuehl — Sat, 25 Jan 2014 13:47:18 GMT

You have included 'Project' in your THEN branch, while you should use it in your condition, IMHO.

=count( if(Status = 'Open' or Status='Project', [Problem ID]))

=count( if(match(Status,'Open','Project'), [Problem ID]))

=count( {<Status = {Open, Project}>} [Problem ID])

Re: Counting Multiple Values

MayilVahanan — Sat, 25 Jan 2014 13:48:25 GMT

Try like this

=count( {<Status = {'Open', 'Project'}>} [Problem ID])

Re: Counting Multiple Values

rustyfishbones — Sat, 25 Jan 2014 14:00:02 GMT

for performance,it's better to use the Set Analysis option

COUNT( {<Status = {'Open','Project'}>} [Problem ID])

Re: Counting Multiple Values

Sat, 25 Jan 2014 14:00:24 GMT

Thanks for your help, I have used =count( if(Status = 'Open' or Status='Project', [Problem ID]))

However when used in a pie chart with the same expression, it seems to be adding Others with zero? even though "Others" is not in any of the tables, Any ideas how to exclude or remove this info so it just shows Project and Open?

Re: Counting Multiple Values

nilesh_gangurde — Sat, 25 Jan 2014 14:02:09 GMT

See You are writing expression as if Status is Open then give Project Id else Give Problem ID, hence its not working.

=Count( if(Status ='Open','Project',([Problem ID])) )

instad of that you can write the following expression.

=Count( if(Status ='Open' or Status = 'Project',([Problem ID])) )

=Count( {<(Status ={'Open' , 'Project'}>}[Problem ID]) )

Hope this will help.

-Nilesh

Re: Counting Multiple Values

rustyfishbones — Sat, 25 Jan 2014 14:03:49 GMT

Check Dimension Limits and that you are not ticking the box to Show Others

Re: Counting Multiple Values

Sat, 25 Jan 2014 14:06:24 GMT

Thanks all for you help - Much Appreciated