Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Erlang C

Hello All,

I am working on a project where I need to calculate the Erlang C.

In excel it is easy but in qlikview it is more difficult.

I managed to do it using variables but I cant get it to work in a table.

Here are the variables I created to calculate the Erlang C:

let vDen = 0;

let vNC = 360;//Number of calls

Let vP = 900;//Period length

Let vT = 120;//Average call duration

let m = 55;//Number of agent

let tt = 30;//Target answer time

Let u = num((($(vNC)/$(vP))*$(vT)),'#0 ');//traffic intensity

Let vOCC = $(u)/$(m);

Let vNUM = num(pow($(u),$(m))/fact($(m)),'#0 ');

for i=0 to $(m)-1

let vDen = $(vDen)+ (pow($(u),$(i))/fact($(i)));

next

let vErlang = Num(vNUM/(vNUM+((1-vOCC)*vDen)),'# ##0.00%');

In the table I am not able to calculate the vDen as I cannot create the loop in the expression tab.

Any Idea?

Thanks,

Hasvine

Community Browser