exp in qlikview expression tab

[#1]

Hello All,

Is it to replicate the below in the expression tab:

for i=0 to $(m)-1

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

next

It works fine in the loading script using variable but I an replicate it in the expression tab using calculated column.

Any idea?

Many Thanks,

Hasvine

[tresesco]

for..next control statement can only be used in script. You can try valueloop()/valuelist() as an alternative in the UI.

[#3]

is there an alternative?

Many Thanks,

Hasvine

[tresesco]

Try to share a qvw explaining your expected output and let us try to find it.

[#5]

I will create an example and post it.

Thanks,

Hasvine

[#6]

Hi,

I have attached a sample qlikview.

I have a first table whereby I used variable in the loading script to calculate the 'probability to wait'

In the second table 'ER', I need to calculate the Probability to wait after the occupation.

However, I cannot do so as I need to use the for..next to calculate the vDen so that I can use the vDen to calculate my Erang.

Many Thanks for your help.

Hasvine

[tresesco]

Sorry, I could not really follow?