topic Re: Aggr Count in QlikView

Aggr Count

Zain2013 — Mon, 29 Apr 2019 10:39:16 GMT

Hi,

need Aggr count based on Br code in the place of one, object name need Aggr count based on br code.

thanks in advance

Regards,

Zain.

Anil_Babu_Samineni — Mon, 29 Apr 2019 12:55:36 GMT

Expected result?

Zain2013 — Mon, 29 Apr 2019 13:40:42 GMT

>20 22

<0 11

>0 - <10 12

>10 - <20 5

Anil_Babu_Samineni — Mon, 29 Apr 2019 16:02:56 GMT

You can simply define as below in measure?

Count(DISTINCT [Br Code])

Zain2013 — Tue, 30 Apr 2019 04:22:30 GMT

applied but not working, you can also find in the application as same.

jonathandienst — Tue, 30 Apr 2019 05:34:01 GMT

Count(Distinct [Br Code]) seems to work just fine.

Zain2013 — Tue, 30 Apr 2019 06:30:37 GMT

expression is not working in my application, kindly share the application.

Regards,
Zain.

Zain2013 — Tue, 30 Apr 2019 06:39:40 GMT

done, I made mistake is no space between distinct and brcode.
have got the requried result.

Thanks,

Regards,

Zain