Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created 2 bar charts where the dimension for first chart is "Level1_Name" and dimension for second chart is "Level2_Name"
with some expressions.
Now I need to have color coding consistent in both the charts for example in Level1_Name = 'A' is Red then Level2_Name i.e. 1-A, 2-A, 3-AA, 4-AAA should have Red,
if Level1_Name = 'B' is in Green Color then Level2_Name i.e 5-BB, 6-BB, 7-B, 8-B should be in green Color. please suggest me how to achieve this
ID | Level1 _Name | Level2_Name |
1 | A | 1-A |
2 | A | 2-A |
3 | A | 3-AA |
4 | A | 4-AAA |
5 | B | 5-BB |
6 | B | 6-BB |
7 | B | 7-B |
8 | B | 8-B |
Hi,
If this is dimension then click on + symbol of that dimenion
You will see font color write expression in that
like
if(wildmatch(level1_Name,'A',Red(),if(wildmatch(level1_Name,'B',Green()))))
Regards
Hi,
If you are using it as dimension or expression then click on Plus sign
and in background write
=if(Match([Level1 _Name],'A'),Green(),Red())
And in
Text Color write
White()
I believe you get this output
Regards
Anand
Hi Savi,
try below in the background color property in your expressions:
=pick(WildMatch(Level1_Name, 'A', 'B'), Green(), Red(), Yellow())
=pick(WildMatch(Level2_Name, 'A', 'B'), Green(), Red(), Yellow())
Regards
Neetha
Hi,
thank u so much for the suggestions, but hardcoding is not allowed in my project, is there any way to get this dynamically without hardcoding values....
Hi,
sorry but if don´t have it on your data model or on your ETL then it will be a difficult task...
Regards
André Gomes
Hi,
Possible but you have to done changes in the load script and create a single Inline table for colors and then use in the front end.
Regards
Anand
Hi,
See below links,you will be able to do:
http://community.qlik.com/message/7923#7923
http://community.qlik.com/blogs/qlikviewdesignblog/2012/12/04/colors-in-charts
Regards
Neetha