Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator 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
Highlighted
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
Creator II
Creator 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!