topic Re: Count if in QlikView

Count if

Wed, 25 Nov 2020 16:16:04 GMT

Dear Community

I am having a difficulty with the following formula:

=Count(if(SUM(Value)/10 > 0.8,[Employee Name])

I am not getting a result.

Please advise

Regards

Anonymous — Thu, 18 May 2017 19:09:35 GMT

Don't know what your data looks like but you can try this.

=if(aggr(sum(Value)/10,[Employee Name])>0.8,count(distinct [Employee Name]),)

ziadm — Thu, 18 May 2017 19:11:09 GMT

missing closing bracket ...

=Count(if(SUM(Value)/10 > 0.8,[Employee Name]))

also you are missing aggr function

Try

=Count(if(Aggr(SUM(Sales),Customer) /10 > 0.8,Customer))

Thu, 18 May 2017 19:21:52 GMT

Thanks , I am still trying but not getting result

Thu, 18 May 2017 19:23:07 GMT

Thanks, Still no result , I will follow the formula, probably missing a bracket somewhere on my side

ziadm — Thu, 18 May 2017 19:23:48 GMT

=Count(if(Aggr(SUM(Sales),[Employee Name]) /10 > 0.8,[Employee Name]))

Thu, 18 May 2017 19:26:39 GMT

Great , thanks a million - works

ziadm — Thu, 18 May 2017 19:30:55 GMT

Please mark correct and close the thread .. Thanks