Qlik Community

Ask a Question

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Sept. 16, Qlik Product Portfolio Strategy and Roadmap for Data Integration 11 AM ET REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

calculation in script

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

 

Labels (1)
  • Other

3 Replies
sergio0592
Specialist III
Specialist III

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

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

may be instead of this 

1.5 + 500,000

try like

1.5 + 500000

 

MayilVahanan

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)

Thanks & Regards,
Mayil Vahanan R