Color by expression

[ccastrilloc]

Hi, many thanks for the extension! I have a expression for dimension's color, but it hasn't any effect. The expression is something like if(Status='2',RGB(0,99,56),if(Status='1',RGB(255,128,0),RGB(127,127,0127)), the same for all the dimensions (4).
Hope you can help me. Many thanks in advance
Best regards

Cesar

[jonvitale]

Cesar,

It looks like the statement will work if you surround the RGB(...) statements with single quotes, like 'RGB(0,99,56)'. (Also, you are missing a closing parenthesis, but I assume that's just a copying error).

I'm not sure why the RGB function needs to be quoted - it's not ideal. I'll try to fix it, but for now can you work with the quotes?

Jonathan

[ccastrilloc]

Hi Jonathan,

yes, it works! But I have another issue: all the colors change when I select one value on any of my four dimensions, i.e, if I have the second dimension orange, when I select it, all the dimensions change their color. Hope you can help me!

Thanks again for your help!

BR/Cesar

[jonvitale]

Can you either take a screenshot, before and after clicking a dimensional node OR upload a Qlik Sense app, so I can see what's up?

By the way, I fixed the RGB problem, so that you won't need to quote it. I'll upload the changes after I deal with whatever this new problem is - if I can.