Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
in the epressions u can write an if condition and assign the
if (x <30,count(customers),
Your [V%a] and [class] columns, are they calculated in script or in chart ?
v%, v%a and Class are calculated at graph
v% = sum(Expression1)/sum(TOTAL Expression1)
v%a = RangeSum(above(Column(2),0,RowNo()))
class = if(column(3)<0.3,1,if(column(3)<0.5,2,if(column(3)<0.8,3,4))))
I need to develop another graph, that does not have Dim4 as a dimension.
You can create a chart with calculated dimension (used fractile as an example, rank() is also suitable):
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))))
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)
I´ll try smething like this