Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ritvik4BI
Partner - Contributor III
Partner - Contributor III

Error in Expression (IF Statement)

Hello Everyone, 

While writing his expression I am gettting an error that IF takes 2-3 parameters. What am I doing wrong?

if(
RangeSum(Above(sum(TotalSales),1,RowNo())) / Sum(TOTAL TotalSales) <=0.8, Green(255),
if(
RangeSum(Above(sum(TotalSales),1,RowNo())) / Sum(TOTAL TotalSales)) <=0.9, Yellow(255),
Red(255)
)
)

1 Reply
Anil_Babu_Samineni

I see, One Parenthesis closed extra which is in red color. Try to remove that and see?

if(RangeSum(Above(sum(TotalSales),1,RowNo())) / Sum(TOTAL TotalSales) <=0.8, Green(255),
if(RangeSum(Above(sum(TotalSales),1,RowNo())) / Sum(TOTAL TotalSales)) <=0.9, Yellow(255),
Red(255)))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful