Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

Color for Dimensions

Hi Folks, 

i got a Situation, where i am using 1 Dimension (Month) and 3 Expressions:

Dimension: Month

3 Expressions:

2016: Sum({<Year= {'2016'}>}[Net Income])

2017:Sum({<Year= {'2017'}>}[Net Income])

2018:Sum({<Year= {'2018'}>}[Net Income])

all this data i have implemented  and grouped in the bar-Chart, my Question is, how can i give to any Expression the color-type, i mean:

2016 =green, 2017 = red, 2018 = yellow,

i tried to resolve but i did not achive any results, because the bar-Chart gives automatic standard-Colors to Expression, if you use one Dimension and a few expressions.

 

does anybody have any idea?

 

Thanks a lot

Beck

1 Solution

Accepted Solutions
Neymar_Jr
Creator II
Creator II

You will have to create 3 master measures and give them the appropriate colors and then use them in the chart. 

View solution in original post

7 Replies
Neymar_Jr
Creator II
Creator II

Hi,

Try adding the measures to Master items. There you would find the option of Measure color, which enables us to color measures differently.

Thanks,

RT

Somasundaram
Creator III
Creator III

Hi,

we can able to achieve using background color properties in expression. 

=If ( year='2016' ,RGB(123,123,123), If(year='2017',RGB(321,321,321), RGB(123,123,123))

Hope it may help.

 

Thanks

 

 


-Somasundaram
beck_bakytbek
Master
Master
Author

Hi Rajesh

 

what do you mean ? as i know, it is possible to use only one Expression in master item or am i missing something?

Neymar_Jr
Creator II
Creator II

You will have to create 3 master measures and give them the appropriate colors and then use them in the chart. 

beck_bakytbek
Master
Master
Author

Hi Somasundaram

thanks a lot for your responce, but it is not possible

beck_bakytbek
Master
Master
Author

i tried, but no results

beck_bakytbek
Master
Master
Author

Hi Rajesh,

your Suggestion is a Right solution, i overlooked some Settings in Color, thanks a lot for your help and time