Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to bring colour 1 to the front of a line graph

I have a line graph with colour 1 being red and this shows the latest month in a selection.

I need the latest selected month to always be red and the selectable months to be variable.

My selections currently get colour 1 as the lastest (which is great) BUT the graph displays colour one at the bottom.

How do I get colour one to be on the top?

I have tried using persistent colours but this does not do what I need.

5 Replies
datanibbler
Champion
Champion

Hi Nick,

if I get you correctly, you could just do what I do routinely: To get some standardization into my colours (and to use the CI_colours where possible), I have created a colour-palette of about 12 colours, stored their values in variables in a qvs_file which is loaded into every Dashboard as an INCLUDE and then use the expression_properties to govern the colour instead of the "colours" tab of the dialog. I think that way is more reliable and makes it easier (for others) to reconstruct which colour I have associated with each expression.

HTH

Best regards,

DataNibbler

nikhilgarg
Specialist II
Specialist II

Hey,

Can you attach the image of Application ?

Thanks

Not applicable
Author

The screenshot of my graph is below. with the current selection Jan-15 is red and I need that on the top.

If I just select Dec-14, Nov-14, Oct-14 I would then need Dec-14 to be red and on the top.

Please be aware that I am very new to qlikview so there may be a simple resolution to this.

screenshot.jpg

Not applicable
Author

Thanks, I think I understand what you mean, I have set the colours (vColorRed, vColorGreen, etc)

How do I assign the colour in the expression rather than using the Colors tab?

chart Properties.png

datanibbler
Champion
Champion

Hi Nick,

well, if you have the "expression_properties" expanded like you have in your screenshot,

the node "Background color" is the one to use.

There you can enter your colour_variable which you have to define beforehand, sth. like

>>> SET v_color_black = rgb(0,0,0); <<<

=> Then you need to use the $() to signal to QlikView that it should evaluate the formula in the variable rather than just return it as a text, so you'll end up (in this example) with

>> = $(v_color_black) <<<

to enter in the edit_field.

HTH

Best regards,

DataNibbler

P.S.: In case you want to find the rgb_values of any colour you like, you can use a text_box - just colour it, using the radiobutton "static", then click on the colour -> you'll get a field of colours and, on the right, three boxes with the three values.