topic Re: text color difference failling in QlikView

text color difference failling

manoranjan_d — Tue, 03 Oct 2017 12:21:37 GMT

Hi all

my text color expression getting failed for below scenarios and expression

I have given the the below expression

if(sum({<[Comparison Date]={'$(vMin)'}>}[Low USD])<>

sum({<[Comparison Date]={'$(vMax)'}>}[Low USD]),RGB(0,0,255),RGB(0,0,0))

example

scenario 1: fail

if the value is same i m getting blue color example

Min Max

800 800

its showing color hence it getting failed

scenario 2: fail

if any ine date have 0 value means

Min Max

800 0

800 is getting blue color but 0 value is in black clor

scenrio 3 : pass

Min Max

800 400

these are showing blue color, this is passed

let me why its getting passed for third scenrio and failed for scenrio 1 and 2.

lety me know the way to resolve this issue

Re: text color difference failling

MarcoARaymundo — Tue, 03 Oct 2017 12:55:16 GMT

Hi, try round function.

if(Round(sum({<[Comparison Date]={'$(vMin)'}>}[Low USD])) <>

Round(sum({<[Comparison Date]={'$(vMax)'}>}[Low USD])),

RGB(0,0,255),

RGB(0,0,0)

)

Re: text color difference failling

vkish16161 — Tue, 03 Oct 2017 13:04:49 GMT

Try this:

if(sum({<[Comparison Date]={'$(=vMin)'}>}[Low USD])<>

sum({<[Comparison Date]={'$(=vMax)'}>}[Low USD]),RGB(0,0,255),RGB(0,0,0))

For troubleshooting you can always try:

if(800=800,rgb(0,0,255),rgb(0,0,0))

Re: text color difference failling

manoranjan_d — Tue, 03 Oct 2017 13:20:36 GMT

its not working

Re: text color difference failling

manoranjan_d — Tue, 03 Oct 2017 13:20:50 GMT

its not wroking

Re: text color difference failling

MarcoARaymundo — Tue, 03 Oct 2017 14:11:53 GMT

if(Sum([Low USD]) = vMin and vMin = vMax,

RGB(0,0,255),

RGB(0,0,0)

)