topic Re: Counting based on acumulated % in QlikView

Counting based on acumulated %

Clever_Anjos — Wed, 05 Dec 2012 21:38:44 GMT

I have a base with similar to this where the first column is "customer name" for example

I need to calculate a graph (not at load script) that shows

Where I am counting how many customers falls below acumulated 30%, how many falls between 30% and 50% and so on.

Any ideas?

shree909 — Wed, 05 Dec 2012 21:46:38 GMT

in the epressions u can write an if condition and assign the

if (x <30,count(customers),

if(30<x<50 ,count(customers

try this

whiteline — Thu, 06 Dec 2012 06:23:48 GMT

Hi.

Your [V%a] and [class] columns, are they calculated in script or in chart ?

Clever_Anjos — Thu, 06 Dec 2012 10:49:02 GMT

v%, v%a and Class are calculated at graph

v% = sum(Expression1)/sum(TOTAL Expression1)

v%a = RangeSum(above(Column(2),0,RowNo()))

and

class = if(column(3)<0.3,1,if(column(3)<0.5,2,if(column(3)<0.8,3,4))))

Clever_Anjos — Thu, 06 Dec 2012 10:49:49 GMT

I need to develop another graph, that does not have Dim4 as a dimension.

whiteline — Thu, 06 Dec 2012 20:05:29 GMT

Hi.

You can create a chart with calculated dimension (used fractile as an example, rank() is also suitable):

aggr(

if(Sum(V)>=fractile(total aggr(Sum(V), Dim4), 0.8), dual('<30%', 0),

if(Sum(V)>=fractile(total aggr(Sum(V), Dim4), 0.6), dual('>=30%<50%', 0.3),

if(Sum(V)>=fractile(total aggr(Sum(V), Dim4), 0.26), dual('>=50%<80%', 0.5), dual('>=80%', 0.8))))

, Dim4)

The problem is I don't know how to calculate fractile parameter dynamicaly according to your percent criteria

As for expresison use just =Count(Dim4)

Clever_Anjos — Fri, 07 Dec 2012 16:18:38 GMT

I´ll try smething like this