Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
manoranjan_d
Specialist
Specialist

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
Partner - Master III
Partner - Master III

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

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
Specialist II
Specialist II

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
Specialist
Specialist
Author

i tried this but its not working

eduardo_dimperio
Specialist II
Specialist II

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

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.

vizmind.eu