topic Re: num function is not working in background color in QlikView

num function is not working in background color

vipingarg23 — Tue, 03 Jul 2018 11:27:12 GMT

Hi Team,

Please find the attachment for sample data.

Here I am using below expression in pivot table:

num(Value,'#,#0.##','.',',')

It is working fine but same is not working in background color. I need that if Value is >0.05 then color should be red otherwise green. for that I am using below expression in bg color:

if(num(Value,'#,#0.##','.',',')>0.05,RGB(242,108,100),green())

I want for ID 2, color should be green instead of red.

Re: num function is not working in background color

stabben23 — Tue, 03 Jul 2018 11:39:38 GMT

Why?

ID2 is larger than 0.05

Re: num function is not working in background color

vipingarg23 — Tue, 03 Jul 2018 12:04:16 GMT

Yes...I know..thats why I am coverting it to 0.05 first then matching with

value.

On Tue, Jul 3, 2018 at 5:10 PM, Staffan Johansson <qcwebmaster@qlikview.com>

Re: num function is not working in background color

stabben23 — Tue, 03 Jul 2018 12:16:44 GMT

if you use this in Your expression

round(Value,0.005)

it will round 0.052 to 0.05 and 0.056 to 0.055

Re: num function is not working in background color

BalaBhaskar_Qlik — Tue, 03 Jul 2018 17:21:36 GMT

may be,

if(num(Value,'#,#0.##','.',',')>0.0500,RGB(242,108,100),green())