How to build line chart?

[#1]

Hi,

I have recently started working on Qlik View and have installed Qlik View 9.0 Personal Edition.

I have a requirement to develop a line chart. My SQL table contains 3 columns for quantities which are historical, forecast and actual. I also have a date column. This table thus has rows which has 3 quantities i.e. Forecast, Actual and Historical quantities for various dates.

Now i need to display these 3 quantities across various dates on a chart, hence i understand that i would be using line chart for this purpose.

On this line chart, i also have a requirement wherein all quantity values which are in future dates compared to current date need to be displayed as dashed lines. Hence the line would be solid till current date and beyond that if there are any entries for future date compared to current date, the line would be dashed or dotted. This needs to be done for all the 3 lines i.e. for historical, actual and forecast.

Can anybody help/suggest me how to develop this type of line chart with dashed/dotted line for future quantity values?

Any help would be greatly appreciated.

Thanks

Anurag

[#2]

Hi Rob,

The function is desribed in Book III Part 1 page 47.

Regards,

Rich De Rocco (See Below)

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

<S

n> 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>.

42

The <W

n> and <Sn

> tags can be freely combined, but only

but only

the first occurrence of each counts. The tags must be

enclosed by single quotations.

[#3]

Have a look at:

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

Best regards

Stefan