Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor

assign background color in edit script window

can we assign background color in the edit script apart from the dimensions box

4 Replies
Highlighted
Valued Contributor

Re: assign background color in edit script window

Hi Sunny. It can be done using a variable.

In the edit script:            vDim1Color = 'If(Dim1 = 'A', Green(), Red())';

In the dimension box:     $(vDim1Color)

Highlighted
Contributor III

Re: assign background color in edit script window

Yes it is possible, if you have the RGB values.

Highlighted
Luminary
Luminary

Re: assign background color in edit script window

Hi,

I've done something like this a few times. Assuming my dimension is [Country]:

Country_Colors:

LOAD * inline [

Country, R, G, B

USA, 255, 0, 0

Germnay, 0, 255, 0

France, 0, 0, 255

];

Then in background color expression I used

RGB(Only(), Only(), Only())

Highlighted
New Contributor

Re: assign background color in edit script window

Thanks for the reply Andrey,

is there possibility to change background color if cell value is changed/updated