Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
for..next control statement can only be used in script. You can try valueloop()/valuelist() as an alternative in the UI.
is there an alternative?
Many Thanks,
Hasvine
Try to share a qvw explaining your expected output and let us try to find it.
I will create an example and post it.
Thanks,
Hasvine
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
Sorry, I could not really follow?