Parameters in variable

[#1]

Hi all,

I have a long function (below) which works fine in EXCEL 2007. I changed the POWER used in this function to POW in order for this function to work in Qlikview. I also replaced the cellname to a variable name($1) and saved it as a variable(xbar_c4). I tried to get a value usingText object with "=$(xbar_c4(6))".  It just somehow does not work. Could you please help?  The Excel and QV files are attached. Thanks

IF(MOD($1,2)=0,SQRT(2/($1-1))*FACT($1/2-1)/(SQRT(PI())/POW(2,$1/2-1)*(FACT($1-3)/(FACT($1/2-2)*POW(2,$1/2-2)))),SQRT(2/($1-1))*((SQRT(PI())/POW(2,($1-1)/2)*(FACT($1-2)/(FACT(($1-3)/2)*POW(2,($1-3)/2)))))/FACT($1/2-1))

Longmatch

[swuehl · Accepted solution]

Try removing the equal sign from the variable definition in variable overview.

[#3]

Works! Thanks