Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
How could i apply different gradient colors as shown above graph?.
Please help me on this. Any idea or suggestion is welcomed.
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
can you share sample?
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
try with Colormix() function.
Thanks it worked.
But i wanted to know, what would be the equation if dimension are dynamic(i mean not constant)