Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
In that case, it would be :
count(total <OutletName> OutletId)
result:
see the attached app:
Try :
Count(Outlet) / count(total{1} Outlet)
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.
you can try this
Count(Outlet) / count(Total Outlet)
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.
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.
Can you share some sample data?
Example 4 outlets values and what do you expect as a result?
about this , thank you Omar
i want to know Total each Outlet
for calculate %Coverage
Can you please share a sample QVF file to directly work on it?
Thanks