topic exp in qlikview expression tab in QlikView

exp in qlikview expression tab

Fri, 02 Dec 2016 07:10:09 GMT

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)));

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

tresB — Fri, 02 Dec 2016 07:15:06 GMT

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

Fri, 02 Dec 2016 07:16:30 GMT

is there an alternative?

Many Thanks,

Hasvine

tresB — Fri, 02 Dec 2016 07:19:36 GMT

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

Fri, 02 Dec 2016 07:24:29 GMT

I will create an example and post it.

Thanks,

Hasvine

Fri, 02 Dec 2016 08:22:11 GMT

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

tresB — Fri, 02 Dec 2016 08:42:57 GMT

Sorry, I could not really follow?