Qlik Community

Ask a Question

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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