Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I would like to calculate % coverage

oultet counting incorrect.jpg

example :

      Outlet A1 total = 150 , and sub group A at Outlet A1 = 12

so

     % coverage = 12/150 that what I want

>>> how to find value 150 ?

help me, i'm new in QlikSense. Thanks.

12 Replies
Not applicable
Author

thank you Omar.

OmarBenSalem
Partner - Champion II
Partner - Champion II

In that case, it would be :

count(total <OutletName> OutletId)

result:

Capture.PNG

see the attached app:

Not applicable
Author

Thank you Omar.