3 Replies Latest reply: Mar 9, 2013 1:20 PM by Grace Rashmi

# How to call the function from straight table

Hi,

I have written a function to calculate the performance bounce.

function Partner_policy( rt , ctr)

dim temprt
dim tempctr

temprt=rt
tempctr=ctr
temp

if (temprt<80 and tempctr<65) then
temp=temprt

elseif ((temprt>=80 and temprt<85) and ctr<65) then
temp=70
elseif ((temprt>=85 and temprt<90) and ctr<65) then
temp=75
end if

Partner_policy=temp
end function

Now i the rt & ctr loaded in straight table. so i want this performance bounce to be loaded in straight table can anyone help me in this.

Regards,

Grace Rashmi

• ###### Re: How to call the function from straight table

You cannot use the function in a straight table. And you don't need the function in the script. Create a new field in the script:

if (rt<80 and ctr<65), rt,

if (rt>=80 and rt<85 and ctr<65, 70,

if (rt>=85 and rt<90 and ctr<65, 75))) as Partner_policy

• ###### Re: How to call the function from straight table

Hi,

Create a variable like this

SET Expression =  if (\$1<80 and \$2<65), rt,

if (\$1>=80 and \$1<85 and \$2<65, 70,

if (\$1>=85 and \$1<90 and \$2<65, 75)))

and use this variable in the expression of straight table

=\$(Expression(rt, ctr))

Refer http://community.qlik.com/docs/DOC-3836 for help.

This calculates the performance in straight table itself.

As per Gysbert Wassenaar   suggestion it is better calculate in the script itself.

Hope this helps you.

Regards,

Jagan.

• ###### Re: How to call the function from straight table

thnks a lot.. it is perfect.