Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table like that :
CODE LABEL
ADCFD Test 1
ESKYRMZ Test 2
12ZSFE45 Test 3
I want to color my label in red when CODE = 'ADCFD' with an expression.
I try like this, but i think something is missing from my expression :
if(CODE='ADCFD',rgb(255,0,0))
Are you sure that you placed the code under the Label column in the settings?
The LABEL color will only change its color based on other dimension if you change the Text color expression under the desired column in the table.
Hi,
The code looks good, but you can try these:
IF(CODE = 'ADCFD','#ff0000',null()) // Hex color
IF(CODE = 'ADCFD',LightRed(),null()) // Qlik color
Can you show an image where you are trying this?
Jordy
Climber
Hi Jordy,
It's ok for the color of column CODE but i want to color in red the column LABEL when CODE = EBITWO.
I put this expression on QLIK SENSE, but it's doesn't work :
IF(CODE = 'EBITWO',LightRed(),null())
Are you sure that you placed the code under the Label column in the settings?
The LABEL color will only change its color based on other dimension if you change the Text color expression under the desired column in the table.
Hi UseCodeMeow,
I had made a mistake in the placement of the formula.
By placing the formula in the right place, I get the label in red.
Thank you 🙂