Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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.

Tags (2)
1 Solution

Accepted Solutions
OmarBenSalem
Esteemed Contributor

Re: I would like to calculate % coverage

In that case, it would be :

count(total <OutletName> OutletId)

result:

Capture.PNG

see the attached app:

12 Replies
OmarBenSalem
Esteemed Contributor

Re: I would like to calculate % coverage

Try :

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

Not applicable

Re: I would like to calculate % coverage

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
Honored Contributor III

Re: I would like to calculate % coverage

you can try this

Count(Outlet) / count(Total Outlet)

Not applicable

Re: I would like to calculate % coverage

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

Re: I would like to calculate % coverage

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
Esteemed Contributor

Re: I would like to calculate % coverage

Can you share some sample data?

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

Not applicable

Re: I would like to calculate % coverage

about this , thank you Omar

outlet2.jpg

Not applicable

Re: I would like to calculate % coverage

i want to know Total each Outlet

for calculate %Coverage

OmarBenSalem
Esteemed Contributor

Re: I would like to calculate % coverage

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

Thanks

Community Browser