topic Re: calculation in script in QlikView

calculation in script

capriconuser — Mon, 26 Jan 2026 16:26:21 GMT

i have premium column now i want to do some calculation in sript

i do this

load id (Premium * 1.5 + 500,000) as Premium_cal from ....

but this shows red line error in script

Re: calculation in script

sergio0592 — Mon, 21 Jun 2021 12:00:13 GMT

Try to use Resident. If Table 1 results of SQL query

Table2: load id, (Premium * 1.5) + 500) as Premium_cal resident Table1;

Re: calculation in script

NitinK7 — Mon, 21 Jun 2021 12:38:32 GMT

may be instead of this

1.5 + 500,000

try like

1.5 + 500000

Re: calculation in script

MayilVahanan — Wed, 23 Jun 2021 01:06:38 GMT

Hi @capriconuser

Due to Comma in the script , Qlik recognized that, line is ended so after that comma its considered the next field or some garbage values & throw error .

so, remove the comma and try again

((Premium * 1.5) + 500000)