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
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.
date([SALE DATE],'DD/MM/YYYY') as [SALE DATE],
"D:\Documents and Settings\XXXXXXX\Desktop\4532.Line chart_data.xls"
(biff, embedded labels, table is [SQL Results$]);
As i said earlier you need to add the below expression in Expression -> expand + -> line Style.
if([SALE DATE] <=today(),'<S1>','<S2>')
Check the attached image for your reference.
Reply me for further clarification.
Hope this may help you.
Dashed Line.jpeg 19.1 K
The function is desribed in Book III Part 1 page 47.
Rich De Rocco (See Below)
Only applicable on line, combo and radar charts. Click on
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
is a multiplying factor to be applied
on the default line width of the chart. The number
a real number between 0.5 and 8. Example: <W2.5>.
The style of the line can be controlled by including a tag
is an integer between 1 and 4 indicating the
style to be used (1=continous, 2= dashed, 3=dotted,
4=dashed/dotted). Example: <S3>.
> tags can be freely combined, but only
the first occurrence of each counts. The tags must be
enclosed by single quotations.
Attached is the application will demonstrate you the qlikview feature.
You need to write the above expression in Expression Tab -> expand + symbol in expression and line style
line chart test.qvw 120.2 K