topic Line style/formatting in charts in QlikView

Line style/formatting in charts

Thu, 23 Sep 2010 17:15:43 GMT

I saw this post yesterday and asked the following question in that thread but no one saw it...

Can anyone tell me where I might find more of these expression values? For instance;

'<S1>' = Solid Line

'<S2>' = Dashed Line

'<S3>' = Etc....

What about line widths..? '<W1>' ? What other options are there? '<R1>'? '<T5>'? '<D3>'? '<K2>'? Anything else....? A comprehensive list would be great!

Thank you.

Line style/formatting in charts

Miguel_Angel_Baeyens — Thu, 23 Sep 2010 17:39:59 GMT

Hello Rob,

Those I know are in page 965 of the PDF document:

S1 Solid, S2 Dashed, S3 Dot S4 Dash/Dot

Wx where x is a value from 0,5 to 8 to set the width of the line.

Regards.

Line style/formatting in charts

Thu, 23 Sep 2010 18:24:31 GMT

Page 965 of the Qlikview Reference Manual.pdf? I don't see it...

Maybe I am looking in the wrong pdf....? Do you have a link to where I should get/see the right one...?

Line style/formatting in charts

Miguel_Angel_Baeyens — Thu, 23 Sep 2010 19:19:49 GMT

Hi Rob,

It's in your Program Files\QlikView\Documentation directory. Page is absolute, not relative (as the PDF consists in three books).

Regards.

Line style/formatting in charts

Mon, 27 Sep 2010 20:37:06 GMT

I think I may still be missing something.. I don't see a reference on page 965. See screenshot below.

Line style/formatting in charts

Anonymous — Mon, 27 Sep 2010 20:47:37 GMT

This is what it sais on page 910:

Line Style
Only applicable on line, combo and radar charts. Click on
Line Style in order to enter an attribute expression for calculating
the line style for the line or line segment associated
with the data point.
The relative width of the line can be controlled by including
a tag <Wn> where n is a multiplying factor to be applied
on the default line width of the chart. The number n must be
a real number between 0.5 and 8. Example: <W2.5>.
The style of the line can be controlled by including a tag
<Sn> where n is an integer between 1 and 4 indicating the
style to be used (1=continous, 2= dashed, 3=dotted,
4=dashed/dotted). Example: <S3>.
The <Wn> and <Sn> tags can be freely combined, but only
the first occurrence of each counts. The tags must be
enclosed by single quotations.

Line style/formatting in charts

Miguel_Angel_Baeyens — Mon, 27 Sep 2010 21:58:49 GMT

Hello Dennis,

That's the text. It's page 965 in my manual. Will check again.

Line style/formatting in charts

Tue, 05 Oct 2010 22:56:13 GMT

Hi,

have a look at the following article I just wrote:

http://www.qlikblog.at/725/qliktip-24-linestyles-linecharts-differentiate-actual-planning-figures/

Best regards

Stefan

Line style/formatting in charts

Tue, 07 Dec 2010 11:48:06 GMT

Hi does anyone have any examples how the Chart properties can be configured for Mini Charts?

There arent many resources available to help with advanced chart attributes.

Im looking for examples of expressions that i can use to configure each of the attributes below

Line style/formatting in charts

Tue, 07 Dec 2010 11:48:50 GMT

Line style/formatting in charts

Mon, 06 Jun 2011 17:47:35 GMT

This is great. I didn't see any documentation for controlling Line Symbols (Square, Dot, etc) in the expression. Is it possible ?

Thanks

Re: Line style/formatting in charts

Mon, 10 Aug 2015 06:26:09 GMT

Hello All,

Is there any way, where we can represent bar charts in following fashion ?

Thanks in advance

Regards

Kiran Shinde

Re: Line style/formatting in charts

Anonymous — Sun, 04 Oct 2015 16:33:47 GMT

Hi Kiran,

You can use '-(<Expression>)' (negative sign in front of second expression) and you can get a chart the way you asked for.

Re: Line style/formatting in charts

Mon, 02 Nov 2015 11:53:26 GMT

How does one make the linear line on a graph dashed?

Re: Line style/formatting in charts

Anonymous — Tue, 23 Feb 2016 13:20:01 GMT

Hi All,

I'm joining the discussion questions - is there any chance to get dashed line bar in bar chart?

Thank you for help!

Best Regards,

Jacek Antek

Re: Line style/formatting in charts

Anonymous — Tue, 14 Feb 2017 12:14:20 GMT

He needs dashed line borders - not negative bars.

Re: Line style/formatting in charts

Anonymous — Tue, 14 Feb 2017 14:15:38 GMT

Hi.

Although it doesnt look possible to have dashed line for bar charts, but you can use other trick.

Instead of changing line style, you can change background color to transparent!

E.g.:

If(Year < Year(Now()),

Color(RowNo()),

ARGB(128, Color(RowNo()) >>16 bitand 255, Color(RowNo()) >>8 bitand 255, Color(RowNo()) bitand 255 )

)