Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

exp in qlikview expression tab

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

6 Replies
tresesco
MVP
MVP

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

Not applicable
Author

is there an alternative?

Many Thanks,

Hasvine

tresesco
MVP
MVP

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

Not applicable
Author

I will create an example and post it.

Thanks,

Hasvine

Not applicable
Author

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
MVP
MVP

Sorry, I could not really follow?