Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
rupaliqlik
Creator
Creator

Color by dimension value in text

Hi Experts,

I have one requirement in QlikSense. But I don't know how to do it as I am new to qliksense.

Add logic to color code the text on the reports based on the dimension Transaction Type. (there is an article on the Qlik Developers site that shows how dimension values can be set up as color coded – this way no logic needs to be added to all of the charts).Transaction Type has below Values,.Can anyone give example on this and explain.?
- Direct = default
- Tracings/Rebates = brown
- Adjustments (all others) = dark blue

Thanks,

Rupali Ethape.

kaushik.solanki‌    stalwar1 @Frank Hartmann

Labels (1)
5 Replies
Channa
Specialist III
Specialist III

i dont think you can change all chart colors by changing one place we need to edit each chart

 

Channa
amrinder
Creator
Creator

Hi Rupali,

In table/pivot under expression properties  go to text color expression and you can write

=if(Transaction='Direct',RGB(164,227,0),If(Transaction='Rebates',RGB(154,227,0),RGB(0,90,160)))

PS:RGB codes can be your need.

 

 

santhiqlik
Creator
Creator

Hi,

In Qliksense, you can color dimension values using master items as shown in below screenshot.Once you create the Dimension in master items, click Edit  then you can see "Value Colors" option. 

 

rupaliqlik
Creator
Creator
Author

Hi,

How to apply to text or chart?

 

Thanks,

Rupali Ethape

Channa
Specialist III
Specialist III

Chart try under presentation properties
Channa