text color change

[manoranjan_d]

How to change the color in qliksense i given thsi condition  in text color change but its not working fine for me

if

(

num(sum(({<[Primary Comparison Date]={'$(vMin)'}>}[ Low USD])),'#.##')<>

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

[lironbaram]

hi

it seems you miss rgb in the first color call

if

(

num(sum(({<[Primary Comparison Date]={'$(vMin)'}>}[ Low USD])),'#.##')<>

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

[beck_bakytbek]

Hi Manoranjan,

maybe you code does not work, becaues you forgot the RGB:

if

(

num(sum(({<[Primary Comparison Date]={'$(vMin)'}>}[ Low USD])),'#.##')<>

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

Beck

[eduardo_dimperio]

Hi Manoranjan,

Have you forget the RGB in the first argument?

if

(

num(sum(({<[Primary Comparison Date]={'$(vMin)'}>}[ Low USD])),'#.##')<>

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

[manoranjan_d]

i tried this but its not working

[eduardo_dimperio]

What your code display?

Try replace (just for test) the RGB for some word, like test1 and test2. So you can check if your "If" is working as you want to.

[Ivan_Bozov]

How about this:

If((Num(Sum({<[Primary Comparison Date]={'$(vMin)'}>}[Low USD]),'#.##') <> Num(Sum({<[Primary Comparison Date]={'$(vMax)'}>}[Low USD]),'#.##')),RGB(0,0,255),RGB(0,0,0))

...or post your app.