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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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