topic Re: line chart style in QlikView

line chart style

Mon, 04 Aug 2014 07:32:48 GMT

Hi,

I try to do a line chart style like this example:

I cannot put a different color/shade below the line.

Any idea?

Thanks a lot,

Eva

Re: line chart style

ashfaq_haseeb — Mon, 04 Aug 2014 07:38:41 GMT

Hi,

Go to chart properties --> colors tab --> and change color of first element.

Look at the attached image.

Or post your sample data.

Regards

ASHFAQ

Re: line chart style

avinashelite — Mon, 04 Aug 2014 07:40:47 GMT

Hi Eva,

I think this is not possible in Qlikview.

Regards,

@vi

Re: line chart style

Mon, 04 Aug 2014 07:50:16 GMT

Hi Guys,

Thanks for your answer!

ASHFAQ : it will change the line color, but not fill below.

What I did so far...

on the sheet style, pick up the pen ultimate style.

On the sheet expressions -> add an expression =15 with a daker background.

It almost works but: 1 it's not really good practice/dev. 2 the resultat is not really beautiful when the scale, size change.

Any other idea?

Re: line chart style

senarath — Mon, 04 Aug 2014 08:39:07 GMT

Hi,

Convert the chart to an Area Chart and see.

thanx

Re: line chart style

Mon, 04 Aug 2014 09:06:48 GMT

Do you know how to get 2 shades with the area. I sidestep QV with 2 expressions. but the rendering is not perfect.

I just added 2 print screens to my previous post.

Re: line chart style

senarath — Mon, 04 Aug 2014 09:23:29 GMT

Hi,

Try selecting your preferred colors under Color --- > Color Scheme 1-6

thanx

Re: line chart style

Mon, 04 Aug 2014 09:59:08 GMT

I cannot make it. colors on the colors sheet allow me to change the line/area with 1 color or a gradiant but not to separate colors.

Re: line chart style

Wed, 06 Aug 2014 02:14:03 GMT

Ok I did in with an overlay of 2 graphs. 1 area, the other one in line with a transparent background.

It's working but it's not a really elegant technical solution...

Re: line chart style

Anonymous — Thu, 07 Aug 2014 00:13:06 GMT

Hi Eva,

As the combo chart doesn't allow line and area you're best option is the transparent overlay you've used. An alternative (which will depend on the granularity of your dimension) may be to use the bar and line combo. Again this isn't an elegant solution but you'll have less layout issues than the overlay.

Re: line chart style

Thu, 07 Aug 2014 00:19:42 GMT

thanks Steve, I really appreciate your help!