topic Re: Color code Expression issue in QlikView

Color code Expression issue

pranubitla — Wed, 25 Nov 2020 16:16:04 GMT

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',

Re: Color code sscript issue

Anil_Babu_Samineni — Fri, 25 Nov 2016 15:39:15 GMT

It's tricky to monitor in image, Can you share the expression on wall.

Updated:

IF (ArrearsBand > 0 AND ArrearsBand <=3 ,'Early Arrears',

IF (ArrearsBand >3 ,'Late Arrears') AS 'ArrearsProfile',

Then use Dim as ArrearsProfile

Re: Color code sscript issue

el_aprendiz111 — Fri, 25 Nov 2016 15:40:35 GMT

hi,

Re: Color code Expression issue

pranubitla — Fri, 25 Nov 2016 15:42:47 GMT

=IF(ArrearsProfile = 'Early Arrears' AND (Sum(CurrentBalance))<.01, RGB(16,163,41),
IF((ArrearsProfile = 'Early Arrears' AND (Sum(CurrentBalance))>.01 AND (ArrearsProfile = 'Early Arrears' AND (Sum(CurrentBalance)) <= .02, RGB(255,255,0),
IF(ArrearsProfile = 'Early Arrears' AND (Sum(CurrentBalance))>.02 AND (ArrearsProfile = 'Early Arrears' AND (Sum(CurrentBalance))<=.03, RGB(255,140,0), RGB(254,51,56))
,
IF(ArrearsProfile = 'Late Arrears' AND Sum(CurrentBalance)<.02, RGB(16,163,41),
IF(ArrearsProfile = 'Late Arrears' AND Sum(CurrentBalance)>.02 AND IF(ArrearsProfile = 'Late Arrears' AND Sum(CurrentBalance)<=.04, RGB(255,255,0))
IF(ArrearsProfile = 'Late Arrears' AND Sum(CurrentBalance)>.04, AND IF(ArrearsProfile = 'Late Arrears' AND Sum(CurrentBalance)<=.06, RGB(255,140,0),RGB(254,51,56))))

Re: Color code Expression issue

pranubitla — Fri, 25 Nov 2016 15:46:42 GMT

Hi Fer, is that a error with dimension.?

Re: Color code sscript issue

Anil_Babu_Samineni — Fri, 25 Nov 2016 15:47:55 GMT

Would you share Application for work? Does it possible to share. So glad to help

Re: Color code Expression issue

pranubitla — Fri, 25 Nov 2016 15:54:57 GMT

Anil, Dimension is ArrearsProfile:

I would like to show the color update based on percentage level on the straight table. , the above expression not getting right. please suggest.

Re: Color code Expression issue

pranubitla — Fri, 25 Nov 2016 15:55:20 GMT

Re: Color code Expression issue

Anil_Babu_Samineni — Fri, 25 Nov 2016 15:58:54 GMT

Try like this, I don't know what was the expression you had tried

If([Arrears Balance %]<=3, Red(), If([Arrears Balance %]>=4 and [Arrears Balance %]<=50, Green(), Yellow()))

Re: Color code Expression issue

vinieme12 — Sat, 26 Nov 2016 09:12:56 GMT

MODIFIED, you only need as below

=IF(ArrearsProfile = 'Early Arrears',

If(Sum(CurrentBalance)<.01, RGB(16,163,41),

IF(Sum(CurrentBalance) <= .02, RGB(255,255,0),

IF( Sum(CurrentBalance)<=.03, RGB(255,140,0),RGB(254,51,56))))

IF(ArrearsProfile = 'Late Arrears',

if(Sum(CurrentBalance)<.02, RGB(16,163,41),

IF(Sum(CurrentBalance)<=.04, RGB(255,255,0),

IF(Sum(CurrentBalance)<=.06, RGB(255,140,0),RGB(254,51,56))))))

Re: Color code Expression issue

pranubitla — Sat, 26 Nov 2016 11:36:49 GMT

Many thanks Anil and Vineeth, got the result. 🙂

Re: Color code Expression issue

vinieme12 — Sat, 26 Nov 2016 11:42:16 GMT

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

Re: Color code Expression issue

pranubitla — Sat, 26 Nov 2016 11:45:30 GMT

Thanks for you help Vineeth