Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
berryandcherry6
Contributor II

Bar graph:Customized colors for Different Dimension

Hi,

I have a bar graph, where i am using customized color(gradient colors) for bars using expression

Color Expression:  ColorMix2( (rank(New_Campaign_Name)/(noofrows(TOTAL)/6))-1 ,rgb(0,112,200),rgb(142,180,227),rgb(198,217,241))

Dimension 1: Email Type

Dimension 2: New Campaign Name

Expression: Sum(emailValue)

Color Expression got from qlikview.

Capture123.PNG

But, now my clients requirement as changed, and they ask me to get bar graph as show below, with gradient colors different for different dimension.

Capture.PNG

How could i apply different gradient colors as shown above graph?.

Please help me on this. Any idea or suggestion is welcomed.

Tags (2)
1 Solution

Accepted Solutions
ahaahaaha
Honored Contributor

Re: Bar graph:Customized colors for Different Dimension

Hi,

May be like this

Color Expression: 

If([Email Type] = 'DELIVERED EMAILS*', ColorMix2( (rank(New_Campaign_Name)/(noofrows(TOTAL)/6))-1, rgb(198,217,241), rgb(0,112,200),rgb(142,180,227)),

If([Email Type] = 'OPEN RATE', ColorMix2( (rank(New_Campaign_Name)/(noofrows(TOTAL)/6))-1,

[expression for green colour],

If([Email Type] = 'CLICK-THROUGH RATE', ColorMix2( (rank(New_Campaign_Name)/(noofrows(TOTAL)/6))-1,

[expression for red colour],

If([Email Type] = 'SIGN UP RATE', ColorMix2( (rank(New_Campaign_Name)/(noofrows(TOTAL)/6))-1,

[expression for purple colour]

))))


Regards,

Andrey

4 Replies

Re: Bar graph:Customized colors for Different Dimension

can you share sample?

ahaahaaha
Honored Contributor

Re: Bar graph:Customized colors for Different Dimension

Hi,

May be like this

Color Expression: 

If([Email Type] = 'DELIVERED EMAILS*', ColorMix2( (rank(New_Campaign_Name)/(noofrows(TOTAL)/6))-1, rgb(198,217,241), rgb(0,112,200),rgb(142,180,227)),

If([Email Type] = 'OPEN RATE', ColorMix2( (rank(New_Campaign_Name)/(noofrows(TOTAL)/6))-1,

[expression for green colour],

If([Email Type] = 'CLICK-THROUGH RATE', ColorMix2( (rank(New_Campaign_Name)/(noofrows(TOTAL)/6))-1,

[expression for red colour],

If([Email Type] = 'SIGN UP RATE', ColorMix2( (rank(New_Campaign_Name)/(noofrows(TOTAL)/6))-1,

[expression for purple colour]

))))


Regards,

Andrey

viveksingh
Contributor II

Re: Bar graph:Customized colors for Different Dimension

try with Colormix() function.

berryandcherry6
Contributor II

Re: Bar graph:Customized colors for Different Dimension

Thanks it worked.

But i wanted to know, what would be the equation if dimension are dynamic(i mean not constant)