Discussion Board for collaboration on QlikView Integration.
i have premium column now i want to do some calculation in sript
i do this
(Premium * 1.5 + 500,000) as Premium_cal
but this shows red line error in script
Try to use Resident. If Table 1 results of SQL query
(Premium * 1.5) + 500) as Premium_cal
may be instead of this
1.5 + 500,000
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)