topic Passing parameter while calling a variable in QlikView

Passing parameter while calling a variable

SureshUK — Wed, 07 Feb 2018 10:27:02 GMT

Hi,

I have a variable which accepts a number as a parameter and returns a number.

I have no problem including this in the chart by passing a value from another from another column.

$(vCalcFinalScore(Score))

but it doesn't work when I call the variable like this:

$(vCalcFinalScore(TextBetween(Score,'|','|',2)))

I am getting an error "TextBetween takes 3-4 parameters"

The column Score is an other expression on the same chart.

Not sure what I am missing here.

Re: Passing parameter while calling a variable

tresB — Wed, 07 Feb 2018 10:30:47 GMT

How do you define the variable?

Re: Passing parameter while calling a variable

SureshUK — Wed, 07 Feb 2018 10:49:49 GMT

The variable vCalcFinalScore has some validations to return a single digit number. A simplified definition looks like this:

if ($1>99 and $1<999, if (substringcount($1,'4')>substringcount($1,'3'),4,3),99)

Re: Passing parameter while calling a variable

tresB — Wed, 07 Feb 2018 10:54:22 GMT

So, you are supposed to pass a number as argument to the variable. And do you expect 'TextBetween(Score,'|','|',2)' to return a number? I guess a sample qvw would be easier to investigate.

Re: Passing parameter while calling a variable

SureshUK — Wed, 07 Feb 2018 11:11:00 GMT

The expression "Final Value-fails" doesn't return anything when I use textbetween function output and as parameter. The "Final Value-works" does return right value when an expression value is passed as parameter.

Re: Passing parameter while calling a variable

tresB — Wed, 07 Feb 2018 11:40:26 GMT

When the variable first encounters with a comma, it terminates as the end of the first argument and that is why you can't pass any value/expression that has comma in between in that way. Alternatively you could have one more variable to hold the expression and pass it in the variable as argument. PFA

Re: Passing parameter while calling a variable

SureshUK — Wed, 07 Feb 2018 11:43:14 GMT

Sorry that I can't open your QVW. I am using v12 personal edition.

Can you please paste both the expression and variables you have included?

Re: Passing parameter while calling a variable

tresB — Wed, 07 Feb 2018 11:44:51 GMT

vText =TextBetween('|123|22|334|3|','|','|',1)

$(vCalcFinalScore(vText))

Re: Passing parameter while calling a variable

SureshUK — Wed, 07 Feb 2018 11:47:40 GMT

This works! Thanks