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
Contributor

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

5 Replies
Highlighted
Valued Contributor III

Re: Color by dimension value in text

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

 

Channa
Highlighted
Contributor

Re: Color by dimension value in text

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.

 

 

Contributor

Re: Color by dimension value in text

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. 

 

Highlighted
Contributor

Re: Color by dimension value in text

Hi,

How to apply to text or chart?

 

Thanks,

Rupali Ethape

Highlighted
Valued Contributor III

Re: Color by dimension value in text

Chart try under presentation properties
Channa