Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

manoranjan_d
Contributor

text color change

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))

6 Replies
lironbaram
Honored Contributor II

Re: text color change

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
Valued Contributor III

Re: text color change

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_dimperi
Valued Contributor II

Re: text color change

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
Contributor

Re: text color change

i tried this but its not working

eduardo_dimperi
Valued Contributor II

Re: text color change

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.

Luminary
Luminary

Re: text color change

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.

Community Browser