topic Re: Re: Count If in QlikView

Count If

Wed, 11 Sep 2013 06:39:26 GMT

Hi Team

Any chance you could help me with a count if expression.

I have a column called Priority which has the following results in it;

0-1 Days

2-6 Days

7+ Days

0-1 Days

I am looking for an expression that counts the number of each of the above. So based on the above, count if "0-1 Days" would return a result of 2.

Hope you can help?

cheers

Re: Count If

tresB — Wed, 11 Sep 2013 07:03:49 GMT

Take priority as a dimension of a staright table, and use Count(Priority) as an expression.

Re: Count If

jagan — Wed, 11 Sep 2013 07:14:06 GMT

Hi,

In chart Select Priority as Dimension and use Count(Priority) as expression, hope this helps you.

Regards,

Jagan.

Re: Count If

Wed, 11 Sep 2013 07:22:52 GMT

Hi Jagan

Thanks for the response however, Priority is not available as a dimension because it is the result of an expression in the straight table. Does that make sense?

Re: Count If

vikram_patro — Wed, 11 Sep 2013 07:30:52 GMT

Do want the result in a chart or at script level?

Re: Count If

Wed, 11 Sep 2013 07:33:12 GMT

In the chart

Re: Count If

vikram_patro — Wed, 11 Sep 2013 07:38:00 GMT

Can you post a sample app?

Re: Count If

tresB — Wed, 11 Sep 2013 07:45:42 GMT

Hello Chris,

Try something like this:

count(If(Aggr(<Your condition to class>,<your dimension in chart>)))

Re: Count If

Thu, 12 Sep 2013 07:26:45 GMT

Hey all.

The two pictures below represent my;

straight table, with the Days column and the Priority columns created using expressions.
an excel view of what I am trying to get Qlikview to achieve.

For each site, I want to show the count of each priority. I am really stuck so any help that I can make sense of would be great.

cheers

Re: Re: Count If

trappersw — Thu, 12 Sep 2013 12:22:45 GMT

Hi there,

You need 2 dimensions:

Site and you add priority as a calculated dimension (normally I would think you can reuse the expression from the straight table as a calculated dimension).

Then as an expression you put the formula of priority between brackets and put count() around it.

This works in the example I inlcuded.

Re: Re: Count If

trappersw — Thu, 12 Sep 2013 12:23:38 GMT

Re: Re: Count If

Fri, 13 Sep 2013 02:12:34 GMT

Hi Wouter

You are a legend. That works well. Thankyou very much.

Re: Count If

trappersw — Fri, 13 Sep 2013 12:06:27 GMT

Hi Chris,

You're welcome. Could you please mark my answer as a correct answer and by doing so close the thread. This way other QlikCommunity-users can see the issue is resolved - and I can build my reputation :-).

Thanks!

Wouter