topic Re: Color code based on Group in QlikView

Color code based on Group

Thu, 22 Jan 2015 12:48:23 GMT

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

Re: Color code based on Group

PrashantSangle — Thu, 22 Jan 2015 12:52:54 GMT

Hi,

If this is dimension then click on + symbol of that dimenion

You will see font color write expression in that

if(wildmatch(level1_Name,'A',Red(),if(wildmatch(level1_Name,'B',Green()))))

Regards

Re: Color code based on Group

its_anandrjs — Thu, 22 Jan 2015 13:01:41 GMT

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

Re: Color code based on Group

Anonymous — Thu, 22 Jan 2015 13:17:07 GMT

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

Re: Color code based on Group

Thu, 22 Jan 2015 13:55:39 GMT

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....

Re: Color code based on Group

agomes1971 — Thu, 22 Jan 2015 14:21:14 GMT

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

Re: Color code based on Group

its_anandrjs — Thu, 22 Jan 2015 14:54:01 GMT

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

Re: Color code based on Group

Anonymous — Thu, 22 Jan 2015 15:00:52 GMT

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