topic Re: Line chart Question in QlikView

Line chart Question

Mon, 21 Oct 2013 02:51:09 GMT

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.

Re: Line chart Question

Mon, 21 Oct 2013 05:03:22 GMT

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

Re: Line chart Question

Mon, 21 Oct 2013 06:15:24 GMT

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.

Re: Line chart Question

Mon, 21 Oct 2013 06:24:05 GMT

Hi Gowri,

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

How to avoid the line from being connected?

Re: Re: Line chart Question

Mon, 21 Oct 2013 06:39:58 GMT

Hi ,

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

Karthik

Re: Line chart Question

Mon, 21 Oct 2013 06:39:59 GMT

Hi,

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

Re: Line chart Question

Mon, 21 Oct 2013 06:41:41 GMT

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.

Re: Line chart Question

Mon, 21 Oct 2013 06:45:42 GMT

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.

Re: Line chart Question

Mon, 21 Oct 2013 06:49:34 GMT

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

All categries are in the same expression.

Re: Line chart Question

Mon, 21 Oct 2013 06:53:12 GMT

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

Re: Re: Line chart Question

Mon, 21 Oct 2013 07:04:43 GMT

Hi,

I feel, we don't have the option to show some dimension's by LIne and some are by symbols. So, you have to use multiple expressions depends on number of dimensions. You probably knew what I meant for. But, anyway see the attachment.

Re: Line chart Question

Thu, 24 Oct 2013 07:47:07 GMT

Hi Venugopal,

You have used separate experssion for each category.

Is it possible to use two expressions, one for Category C and the other expression for the rest of categories? Thanks.

Re: Line chart Question

Thu, 24 Oct 2013 10:58:22 GMT

Hi,

Yes that is possible. Modify the set expression accordingly.

Re: Line chart Question

Fri, 25 Oct 2013 01:05:53 GMT

I've tried to modify the set expression but the chart is not shown as expected.

It groups all other categories in one line but I want to show each category separately on the line chart.

I've attached my modified qlikview file. Would you please advise?

Re: Re: Line chart Question

jagan — Fri, 25 Oct 2013 02:24:10 GMT

Hi,

Please find attached file for solution, hope this is what you are expecting.

Regards,

Jagan.

Re: Re: Line chart Question

Fri, 25 Oct 2013 02:30:11 GMT

I also want to show one of the categories by symbol instead of line. Is it possible?

Re: Re: Re: Line chart Question

jagan — Fri, 25 Oct 2013 03:01:28 GMT

Hi,

I think it is not possible, but you can differentiate the Line from others. Please find attached file.

Regards,

Jagan.