Line chart Question

[#1]

Is it possible to create a line chart in Qlikview similar to the attached Excel file?

One of the lines only shows symbol because some data points are null.

Thanks.

[#2]

If A,B,C,D,E are fixed values..

I feel as its possible. But not tested..

first you need to convert raw data using cross table like below..

A	2008	99
B	2008	55
C	2008	90
D	2008	85
E	2008	59
A	2009	85
B	2009	60
D	2009	90
E	2009	66

then you have to create difference expressions for (A/B/C/D/E) using set analysis.. Now you can set difference style..

Karthik

[#3]

Hi YC,

Please find attached the application that you need.

If the category C have only 2 values it will be still connected with a line.

[#4]

Hi Gowri,

This is my problem. I want to show two data points for Category C.

How to avoid the line from being connected?

[#5]

Hi ,

Find attachment.. But it will work only if "Category" contain fixed values../

Karthik

[#6]

Hi,

You just uncheck display option - Line and Check Symbol for your Category C expression.

[#7]

Hi YC,

If you say always for Category C, you want only symbols not lines then it is possible, but if your requirement is based on data availability of each node, system wants to dynamically decide whethr to show line or not, then it is not possible.

[#8]

I can't uncheck line and check symbol for a particular line.

After unchecking line and checking symbol, only symbols for all categories are shown on the chart.

[#9]

In a Line Chart, how to make show some categories by Line and some by symbols?

All categries are in the same expression.

[#10]

no choice, you have to use seperate expression for each category. Sum(If())