Skip to main content
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.

1 Solution

Accepted Solutions
OmarBenSalem

In that case, it would be :

count(total <OutletName> OutletId)

result:

Capture.PNG

see the attached app:

View solution in original post

12 Replies
OmarBenSalem

Try :

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

Not applicable
Author

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.

arulsettu
Master III
Master III

you can try this

Count(Outlet) / count(Total Outlet)

Not applicable
Author

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.

Not applicable
Author

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.

OmarBenSalem

Can you share some sample data?

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

Not applicable
Author

about this , thank you Omar

outlet2.jpg

Not applicable
Author

i want to know Total each Outlet

for calculate %Coverage

OmarBenSalem

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

Thanks