Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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.

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

In that case, it would be :

count(total <OutletName> OutletId)

result:

Capture.PNG

see the attached app:

View solution in original post

12 Replies
Highlighted
Partner
Partner

Try :

Count(Outlet) / count(total{1} Outlet)

Highlighted
Not applicable

Omar, thank you.


but I would like to get value Total per each outlet.

and your code , it return Total all outlet after i tried.

Highlighted
Master III
Master III

you can try this

Count(Outlet) / count(Total Outlet)

Highlighted
Not applicable

Arul, thank you.


but I would like to get value Total per each outlet.

and your code , it returned Total all outlet after i tried.

Highlighted
Not applicable

outlet2.jpg

I would like to get value total like 150,80,45 as sample

but i don't know how to writing script 

thank you so much.

Highlighted
Partner
Partner

Can you share some sample data?

Example 4 outlets values and what do you expect as a result?

Highlighted
Not applicable

about this , thank you Omar

outlet2.jpg

Highlighted
Not applicable

i want to know Total each Outlet

for calculate %Coverage

Highlighted
Partner
Partner

Can you please share a sample QVF file to directly work on it?

Thanks