Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I would like to know if it is possible to create variables in the expression tab:
If yes, can you please help me with an example.
Many Thanks,
Hasvine
What's the use case? Why not create the variable in the variable overview (Ctrl + Alt + V)?
Hi Sunny,
Hope you are fine. I am having a huge issue with calculating Erlang C in qlikview.
I have created a discussion but no answer till now : Erlang C
Actually using variable i can use the:
for i=0 to $(m)-1
let vDen = $(vDen)+ (pow($(u),$(i))/fact($(i)));
next
But in a table it is more complex I cant use the variable.
This is the formula I am trying to use to calculate the Erlang C:
=NUM((pow(([Appels Reçus]/vP*[TMT en secs]),[Agents])/fact([Agents]))
/((pow(([Appels Reçus]/vP*[TMT en secs]),[Agents])/fact([Agents]))+exp(1-([Appels Reçus]/vP*[TMT en secs]))*(0 + (pow(([Appels Reçus]/vP*[TMT en secs]),Valueloop(0,[vA],1))/fact(Valueloop(0,[vA],1))))),'# 0%')
Do you have any idea on this one.
Thanks for your help.
Kind Regards,
Hasvine
You want to get the value from this
(2*4)*5
Or this
2*(4/5)
I didn't understand your expression