topic How to build line chart? in QlikView

How to build line chart?

Tue, 25 May 2010 08:31:32 GMT

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

How to build line chart?

Tue, 25 May 2010 08:44:32 GMT

Hi,

Its very much possibel. Can pls post sample data in excel wich will contain your date, history, forecast and actual sales data with your o/p?

-Peterson

How to build line chart?

Tue, 25 May 2010 09:47:28 GMT

Hi,

Attached is the application will demonstrate you the qlikview feature.


if((Day)<9,'<S1>','<S2>')

You need to write the above expression in Expression Tab -> expand + symbol in expression and line style

-Peterson

How to build line chart?

Tue, 25 May 2010 09:54:41 GMT

Hi Kevin,

As you mentioned, i am attaching a sample excel data (Line chart_data.xls).

Also would request, that if you are attaching some example using this excel data, plz give it in such a way that it opens on the Qlik View 9.0 Personal Edition on my machine.

Please let me know if you need any other inputs.

Thanks and Regards

Anurag[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/674/4532.Line-chart_5F00_data.xls:550:0]

How to build line chart?

Tue, 25 May 2010 10:09:01 GMT

Hi Anurag

Can u pleas show the chart on excel actually what u wants?

thanks

Zaman

How to build line chart?

Tue, 25 May 2010 10:29:26 GMT

Hi Anu,

I do have personnel edition. So if i post a application also you'll not be able to open my application and don't try to open as well, Since you'll have only 4 recoveries for the personnel edition.

Ok, coming to the point now. Your script should be as follow.


LOAD PLACE,
 date([SALE DATE],'DD/MM/YYYY') as [SALE DATE],
 [HISTORICAL (KGs)],
 [FORECAST (KGs)],
 [ACTUAL (KGs)]
FROM
"D:\Documents and Settings\XXXXXXX\Desktop\4532[1].Line chart_data.xls"
(biff, embedded labels, table is [SQL Results$]);
[\Code]
As i said earlier you need to add the below expression in Expression -> expand + -> line Style.
[Code]
if([SALE DATE] <=today(),'<S1>','<S2>')

Check the attached image for your reference.

Reply me for further clarification.

Hope this may help you.

-Peterson

How to build line chart?

Tue, 25 May 2010 12:56:03 GMT

Hi Kevin,

Thanks for your reply. It worked in my case too.

Appreciate your inputs.

Zaman,

Kevin already attached the output chart in one of his earlier posts which was what i was looking for.

Thanks again for your help.

Anurag

How to build line chart?

Wed, 22 Sep 2010 20:45:05 GMT

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

Thank you.

How to build line chart?

Mon, 27 Sep 2010 20:18:38 GMT

I would like to know this as well..

How to build line chart?

Mon, 27 Sep 2010 20:33:09 GMT

I created a new post HERE for this question since I did not get many answers...

How to build line chart?

Mon, 27 Sep 2010 21:30:54 GMT

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

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

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

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.

How to build line chart?

Tue, 05 Oct 2010 22:58:56 GMT

Have a look at:

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

Best regards

Stefan