topic Re: Count number in QlikView

Count number

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a table that has the center, count date, count.

Center	Count Date	Count	Completed
500	2/1/2016	0	0
	2/2/2016	0	0
	2/3/2016	0	0
	2/4/2016	0	0
	2/5/2016	0	0
	2/8/2016	0	0
	2/9/2016	0	0
	2/10/2016	4385	1
	2/11/2016	4180	1
	2/12/2016	4192	1
	2/15/2016	4217	1
	2/16/2016	20	1
	2/17/2016	20	1
	2/18/2016	31	1
	2/19/2016	51	1
	2/22/2016	110	1
	2/23/2016	81	1
	2/24/2016	81	1
	2/25/2016	86	1
	2/26/2016	649	1
	2/29/2016	690	1
	Total	18793	14

I want to get to total times that a center had a count greater than 0. (So I am trying to create the Completed collum to get the totals.)

Re: Count number

swuehl — Tue, 08 Mar 2016 22:26:28 GMT

Try an expression like

=Count({<Count = {">0"}>} DISTINCT [Count Date])

Re: Count number

sunny_talwar — Tue, 08 Mar 2016 22:42:09 GMT

You can also try:

Sum(Aggr(If(CountExpression > 0, 1, 0), Center, [Count Date]))

Re: Count number

swuehl — Tue, 08 Mar 2016 22:48:44 GMT

Right, if Count in your table is an expression, not a field in a resident table, you can't use my set expression.

Then go with Sunny's solution where CountExpression needs to be replaced with the table chart expression you are using, of course (i.e. you can't use a column reference here).

Re: Count number

clondono — Tue, 08 Mar 2016 23:00:06 GMT

Thank you Sunny, this helped me with an issue I am having on one of my apps!

Incorrect Null count in straight table

You rock!

Re: Count number

Anonymous — Wed, 09 Mar 2016 13:51:55 GMT

Sunny's solution is still giving me all 0s even if the Count is greater then 0.

Re: Count number

swuehl — Wed, 09 Mar 2016 17:30:27 GMT

Could you post the expression you are using? Or maybe even a small sample QVW?

Re: Count number

clondono — Wed, 09 Mar 2016 18:34:14 GMT

See attached QV sample I created using Sunny's expression. It returns the correct count.