topic Re: nested if statement in load script error in QlikView https://community.qlik.com/t5/QlikView/nested-if-statement-in-load-script-error/m-p/1060713#M355132 <HTML><HEAD></HEAD><BODY><P>I see you have used Sum in your script. Do you have Group By Statement to go with it?</P></BODY></HTML> Wed, 23 Mar 2016 20:05:30 GMT sunny_talwar 2016-03-23T20:05:30Z nested if statement in load script error https://community.qlik.com/t5/QlikView/nested-if-statement-in-load-script-error/m-p/1060711#M355130 <HTML><HEAD></HEAD><BODY><P>IF([Status]='Authorized', <SPAN style="font-size: 10pt; line-height: 1.5em;">IF([field1]+</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">[field2]&lt;=0,0,</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">([field3]/([field1]+[field2]))*100), </SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">Sum ([field4</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">])) as [output],</SPAN></P><P></P><P>I am getting an error. the first part of the script is to get the denominator to not equal 0.</P><P></P><P>Assistance is appreciated!!!!!</P></BODY></HTML> Wed, 23 Mar 2016 19:15:51 GMT https://community.qlik.com/t5/QlikView/nested-if-statement-in-load-script-error/m-p/1060711#M355130 2016-03-23T19:15:51Z Re: nested if statement in load script error https://community.qlik.com/t5/QlikView/nested-if-statement-in-load-script-error/m-p/1060712#M355131 <HTML><HEAD></HEAD><BODY><P>"<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">I am getting an error." which error message?</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Which QlikView version?</SPAN></P></BODY></HTML> Wed, 23 Mar 2016 20:03:37 GMT https://community.qlik.com/t5/QlikView/nested-if-statement-in-load-script-error/m-p/1060712#M355131 Clever_Anjos 2016-03-23T20:03:37Z Re: nested if statement in load script error https://community.qlik.com/t5/QlikView/nested-if-statement-in-load-script-error/m-p/1060713#M355132 <HTML><HEAD></HEAD><BODY><P>I see you have used Sum in your script. Do you have Group By Statement to go with it?</P></BODY></HTML> Wed, 23 Mar 2016 20:05:30 GMT https://community.qlik.com/t5/QlikView/nested-if-statement-in-load-script-error/m-p/1060713#M355132 sunny_talwar 2016-03-23T20:05:30Z