topic Re: Set Analysis and Count if in QlikView

Set Analysis and Count if

Wed, 25 Nov 2020 16:16:04 GMT

Dear Community

Please an i as advise on the following:

Below is my formula

=count(if(Aggr(SUM(Value),[Employee Name]) /10 > 0,{<Week={1}>},[Employee Name]))

I am not sure where to place the Set analysis because currently I have an error in the expression

Please advise

Many Thanks

Anil_Babu_Samineni — Tue, 06 Jun 2017 10:07:43 GMT

May be this?

count(if(Aggr(Sum({<Week={1}>}Value),[Employee Name]) /10) > 0,[Employee Name])

Tue, 06 Jun 2017 10:17:06 GMT

Thanks for the quick response, however I still have an error in expresion

Regards

Anil_Babu_Samineni — Tue, 06 Jun 2017 10:19:47 GMT

Could be issue over 10. Would you able to share sample

Tue, 06 Jun 2017 10:26:07 GMT

I cannot share, sensitive info contained. but I can see the expression editor is placing the red line behind the bracket of the 10. If this helps

=count(if(Aggr( Sum({<Week={1}>}Value),[Employee Name]) /10)> 0,[Employee Name])

Anonymous — Tue, 06 Jun 2017 10:27:53 GMT

try aggr(nodistinct ...

avinashelite — Tue, 06 Jun 2017 10:30:27 GMT

try like this

=count(if(Aggr( Sum({<Week={1}>}Value),[Employee Name]) /10> 0,[Employee Name]))

Tue, 06 Jun 2017 10:47:28 GMT

thank you

avinashelite — Tue, 06 Jun 2017 10:48:53 GMT

Glad to help you

sunny_talwar — Tue, 06 Jun 2017 11:06:10 GMT

Just for a try, this might work as well

=Count({<Week={1}, [Employee Name] = {"=Sum(Value) > 0"}>} [Employee Name])