topic Re: Parameters in variable in QlikView https://community.qlik.com/t5/QlikView/Parameters-in-variable/m-p/392584#M146441 <HTML><HEAD></HEAD><BODY><P>Works! Thanks</P></BODY></HTML> Mon, 08 Oct 2012 21:09:44 GMT 2012-10-08T21:09:44Z Parameters in variable https://community.qlik.com/t5/QlikView/Parameters-in-variable/m-p/392582#M146439 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>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 "<SPAN style="font-size: 8pt;">=</SPAN><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">$(xbar_c4(6))".&nbsp; It just somehow does not work. Could you please help?&nbsp; The Excel and QV files are attached. Thanks</EM></STRONG></EM></STRONG></P><P><EM style="color: #808080; font-size: 8pt;"></EM></P><P></P><P></P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">IF</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">MOD</SPAN><SPAN style="font-size: 8pt;">($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)) </SPAN></P><P></P><P>Longmatch</P><P></P></BODY></HTML> Mon, 08 Oct 2012 20:21:25 GMT https://community.qlik.com/t5/QlikView/Parameters-in-variable/m-p/392582#M146439 2012-10-08T20:21:25Z Re: Parameters in variable https://community.qlik.com/t5/QlikView/Parameters-in-variable/m-p/392583#M146440 <HTML><HEAD></HEAD><BODY><P>Try removing the equal sign from the variable definition in variable overview.</P></BODY></HTML> Mon, 08 Oct 2012 20:25:03 GMT https://community.qlik.com/t5/QlikView/Parameters-in-variable/m-p/392583#M146440 swuehl 2012-10-08T20:25:03Z Re: Parameters in variable https://community.qlik.com/t5/QlikView/Parameters-in-variable/m-p/392584#M146441 <HTML><HEAD></HEAD><BODY><P>Works! Thanks</P></BODY></HTML> Mon, 08 Oct 2012 21:09:44 GMT https://community.qlik.com/t5/QlikView/Parameters-in-variable/m-p/392584#M146441 2012-10-08T21:09:44Z