Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creation of Variable in Expression tab

Hello All,

I would like to know if it is possible to create variables in the expression tab:

Capture.PNG

If yes, can you please help me with an example.

Many Thanks,

Hasvine

4 Replies
sunny_talwar

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

agomes1971
Specialist II
Specialist II

Hi,

please read this

The Magic of Variables

HTH

André Gomes

Not applicable
Author

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.

Capture1.PNG

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful