topic Re: Error:Error in expression: Len takes 1 parameter in QlikView https://community.qlik.com/t5/QlikView/Error-Error-in-expression-Len-takes-1-parameter/m-p/936355#M955177 <HTML><HEAD></HEAD><BODY><P>You should actually show an example of your expression used to help us understanding the issue.</P><P></P><P>I assume you are expanding the variable, and it expands to something having commas, and you do this without encapsulation in single quotes:</P><P></P><P>vVar = 1, 2, 3</P><P></P><P>then don't do</P><P>=Len( $(vVar) ) </P><P></P><P>instead </P><P>=Len( '$(vVar)' )</P><P>or maybe only</P><P>=Len( vVar )</P></BODY></HTML> Thu, 19 Nov 2015 14:41:58 GMT swuehl 2015-11-19T14:41:58Z Error:Error in expression: Len takes 1 parameter https://community.qlik.com/t5/QlikView/Error-Error-in-expression-Len-takes-1-parameter/m-p/936354#M955176 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I am new to Qlikview and my current project is my first try at developing applications in Qlikview. I am trying to find <SPAN style="font-size: 13.3333px; line-height: 1.5em;">l</SPAN><SPAN style="font-size: 13.3333px; line-height: 1.5em;">ength of variables and if the length is greater than '0' then show a particular expression in graph. However, when I try to use this len() function I get the following error:</SPAN></P><P></P><P><STRONG>"Error: Error in expression: Len takes 1 parameter"</STRONG></P><P></P><P>Could anyone please explain this behavior?</P><P></P><P>Thanks i<SPAN style="font-size: 13.3333px; line-height: 1.5em;">n Advance!</SPAN></P></BODY></HTML> Thu, 19 Nov 2015 04:42:50 GMT https://community.qlik.com/t5/QlikView/Error-Error-in-expression-Len-takes-1-parameter/m-p/936354#M955176 2015-11-19T04:42:50Z Re: Error:Error in expression: Len takes 1 parameter https://community.qlik.com/t5/QlikView/Error-Error-in-expression-Len-takes-1-parameter/m-p/936355#M955177 <HTML><HEAD></HEAD><BODY><P>You should actually show an example of your expression used to help us understanding the issue.</P><P></P><P>I assume you are expanding the variable, and it expands to something having commas, and you do this without encapsulation in single quotes:</P><P></P><P>vVar = 1, 2, 3</P><P></P><P>then don't do</P><P>=Len( $(vVar) ) </P><P></P><P>instead </P><P>=Len( '$(vVar)' )</P><P>or maybe only</P><P>=Len( vVar )</P></BODY></HTML> Thu, 19 Nov 2015 14:41:58 GMT https://community.qlik.com/t5/QlikView/Error-Error-in-expression-Len-takes-1-parameter/m-p/936355#M955177 swuehl 2015-11-19T14:41:58Z Re: Error:Error in expression: Len takes 1 parameter https://community.qlik.com/t5/QlikView/Error-Error-in-expression-Len-takes-1-parameter/m-p/936356#M955178 <HTML><HEAD></HEAD><BODY><P>What exactly is your expression?</P></BODY></HTML> Thu, 19 Nov 2015 14:45:41 GMT https://community.qlik.com/t5/QlikView/Error-Error-in-expression-Len-takes-1-parameter/m-p/936356#M955178 sunny_talwar 2015-11-19T14:45:41Z Re: Error:Error in expression: Len takes 1 parameter https://community.qlik.com/t5/QlikView/Error-Error-in-expression-Len-takes-1-parameter/m-p/936357#M955179 <HTML><HEAD></HEAD><BODY><P>Thank you! That worked! </P></BODY></HTML> Sun, 22 Nov 2015 22:35:52 GMT https://community.qlik.com/t5/QlikView/Error-Error-in-expression-Len-takes-1-parameter/m-p/936357#M955179 2015-11-22T22:35:52Z