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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
pranubitla
Contributor II
Contributor II

Color code Expression issue

Dear Experts, could any one help with my attached script error. all i am trying to do apply color coading based on percentage  levels for
"Early arrears" and  "late arrears" ,


Details: Straight table dimention is "Arrearsprofile" , expression is sum(Current balance)
Backend script Dimension caluculated like this
  IF (ArrearsBand > 0 AND ArrearsBand <=3 ,'Early Arrears',
    IF (ArrearsBand >3 ,'Late Arrears',)) AS   'ArrearsProfile',  

12 Replies
pranubitla
Contributor II
Contributor II
Author

Many thanks Anil and Vineeth, got the result.   🙂

vinieme12
Champion III
Champion III

Hi, i've modified the expression in post above, try and check this should be all you need

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
pranubitla
Contributor II
Contributor II
Author

Thanks for you help Vineeth