Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try to use Resident. If Table 1 results of SQL query
Table2:
load
id,
(Premium * 1.5) + 500) as Premium_cal
resident Table1;
may be instead of this
1.5 + 500,000
try like
1.5 + 500000
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)