Creation of Variable in Expression tab

[#1]

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

[sunny_talwar]

What's the use case? Why not create the variable in the variable overview (Ctrl + Alt + V)?

[agomes1971]

Hi,

please read this

The Magic of Variables

HTH

André Gomes

[#4]

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

[Anil_Babu_Samineni]

You want to get the value from this

(2*4)*5

Or this

2*(4/5)

I didn't understand your expression