Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor II

Aggregate Count Function

Hello,

Please see the issue I'm facing and the desired result that I'm trying to achieve. The desired result needs to be a Straight Table chart. Could someone please help me get the desired result?

Here is my database table:

AccountNumberOrderNumber
Complete
A0001100.001Y
A0001100.002Y
A0001100.003N
A0002100.005Y
A0002100.006N
A0003100.007N

Desired result in a Straight table Chart:
NB: Complete% calculation is total Complete 'Y' by AccountNumber divide by Total OrderNumber by AccountNumber.

AccountNumberComplete%
A000166.67%
A000250%
A00030%

Currently, I am getting the total Complete% of the overall OrderNumbers instead of OrderNumbers by AccountNumber.

AccountNumberComplete%
A000133.33%
A000216.67%
A00030%

Thank you!

Tags (1)
2 Replies
MVP & Luminary
MVP & Luminary

Re: Aggregate Count Function

You are probably using the keyword TOTAL, which is not necessary here.

Something along these lines should work:

count({<Complete={'Y'}>} distinct OrderNumber)/

count(distinct OrderNumber)


You can learn more about Set Analysis and advanced aggregation in my book QlikView Your Business: An Expert Guide to Business Discovery with QlikView and Qlik Sense


Cheers,

OlegTroyansky

Highlighted
Contributor II

Re: Aggregate Count Function

‌I think I did use the word “Total”. I will check back the application and update more information tomorrow. Thank you!