Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Line chart Question


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.

16 Replies
Highlighted
Not applicable

Re: Line chart Question

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

A200899
B200855
C200890
D200885
E200859
A200985
B200960
D200990
E200966

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

Karthik

Highlighted
Not applicable

Re: Line chart Question

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.

Highlighted
Not applicable

Re: Line chart Question

Hi Gowri,

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

How to avoid the line from being connected?

Highlighted
Not applicable

Re: Re: Line chart Question

Hi ,

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

Karthik

Highlighted
Not applicable

Re: Line chart Question

Hi,

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

Highlighted
Not applicable

Re: Line chart Question

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.

Highlighted
Not applicable

Re: Line chart Question

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.

Highlighted
Not applicable

Re: Line chart Question

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

All categries are in the same expression.

Highlighted
Not applicable

Re: Line chart Question

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