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: 
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