topic Re: Table Links and Sums in Scripts, Create new field. in QlikView

Table Links and Sums in Scripts, Create new field.

bnelson111 — Wed, 25 Nov 2020 16:16:04 GMT

Was trying new ways to load data from different tables then add. Below is a script which successfully loads the data but i cant manage to calculate the new field "F". The calculation is required in the load statement as i want to sum the results in presentation. Any suggestions, thanks Brett

[link]:

SQL SELECT t0."estp-blank-l",

t0."estp-blank-w",

t0."k-est-code",

t1."estrc-coverage",

t1."estrc-weight-qty",

t1."estrc-usage",

t1.kinkcode,

t2.JobCode,

t3.OrderedQty

// num((((((((([t0.estp-blank-l]*[t0.estp-blank-w])/1000)/1000)/100)*[t1.estrc-coverage])*t3OrderedQty)*[t1.estrc-usage])/1000)) as f

FROM

PUB.estprofile as t0,

PUB.estrcoat as t1,

PUB."PV_Job" as t2,

PUB."PV_JobLine" as t3

where t0."k-est-code" = t1."k-est-code"

and t0."k-est-code"=t2.EstCode

and t2.JobCode = t3.JobCode;

Re: Table Links and Sums in Scripts, Create new field.

sinanozdemir — Thu, 07 Apr 2016 17:22:03 GMT

Hey Brett,

By just looking at the formula, it seems like you are missing "." in "t3OrderedQty". Maybe try to change it to "t3.OrderedQty" in order to see if it works.

Hope this helps.

Re: Table Links and Sums in Scripts, Create new field.

bnelson111 — Fri, 08 Apr 2016 11:12:06 GMT

Yep was a issue on the script line.

((( (((t0."estp-blank-l"*t0."estp-blank-w")/1000000)*t1."estrc-coverage")*(t3.OrderedQty+2500))*t1."estrc-usage")/100000) as "Calculated Ink Kg"

now working.