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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
vipingarg23
Creator
Creator

num function is not working in background color

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.

4 Replies
stabben23
Partner - Master
Partner - Master

Why?

ID2 is larger than 0.05

vipingarg23
Creator
Creator
Author

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>

stabben23
Partner - Master
Partner - Master

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

balabhaskarqlik

may be,

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