Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

nested if statement in load script error

IF([Status]='Authorized', IF([field1]+[field2]<=0,0,([field3]/([field1]+[field2]))*100), Sum ([field4])) as [output],

I am getting an error. the first part of the script is to get the denominator to not equal 0.

Assistance is appreciated!!!!!

1 Solution

Accepted Solutions
sunny_talwar

I see you have used Sum in your script. Do you have Group By Statement to go with it?

View solution in original post

2 Replies
Clever_Anjos
Employee
Employee

"I am getting an error." which error message?

Which QlikView version?

sunny_talwar

I see you have used Sum in your script. Do you have Group By Statement to go with it?