topic Re: How to call the function from straight table in QlikView

How to call the function from straight table

Sat, 09 Mar 2013 10:43:58 GMT

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

Gysbert_Wassenaar — Sat, 09 Mar 2013 11:19:27 GMT

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

jagan — Sat, 09 Mar 2013 12:53:11 GMT

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))

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.

Sat, 09 Mar 2013 18:20:07 GMT

thnks a lot.. it is perfect.