topic Re: Line chart in QlikView

Line chart

Anonymous — Tue, 20 Oct 2015 13:34:02 GMT

I have 3 columns based on the data value i want to show line chart-

id	Open	closed	status
1	9/1/2015	9/2/2015	closed
2	9/1/2015	9/1/2015	closed
3	9/2/2015	9/2/2015	closed
4	9/3/2015	9/3/2015	closed
5	9/4/2015	9/5/2015	closed
6	9/5/2015	9/5/2015	closed
7	9/5/2015		open

Re: Line chart

Tue, 20 Oct 2015 13:49:15 GMT

Sumun, you need to create a new table like below in the script.

id Date Status

1 9/1/2015 Open

1 9/2/2015 Close

2 9/1/2015 Close

Re: Line chart

Anonymous — Tue, 20 Oct 2015 13:59:58 GMT

Thanks for your mail.

Please help me to construct the expression

Re: Line chart

jonathandienst — Tue, 20 Oct 2015 14:08:56 GMT

Build a qvw model with the data and make your best effort. Then, when you get stuck, you can ask for some assistance. If you have shown that you have put some effort in yourself, you will get much more help from others.

Re: Line chart

miguelbraga — Tue, 20 Oct 2015 14:36:35 GMT

Here Suman take a look

Notes, the charts have the same results because there are the same 'open' and 'closed' numbers of id's

Re: Line chart

Anonymous — Wed, 21 Oct 2015 04:12:12 GMT

That means we need to change the file structure?Without change the structure how can I do that...please help

Re: Line chart

Anonymous — Wed, 21 Oct 2015 04:37:02 GMT

Hi,

It is not possible for me to change the file structure.

Open depends on requested date and closed depends on resolved date.

Re: Line chart

Anonymous — Wed, 21 Oct 2015 07:29:09 GMT

Thanks for your suggestion ..I have tried but couldn't.

Please help how can we do without change the table structure.

Re: Line chart

jagan — Wed, 21 Oct 2015 07:54:28 GMT

Hi Suman,

Without changing the script it is not possible to handle this, change your script like below

Data:

LOAD

id,

Open AS Date,

'Day' & Day(Open) AS Day,

'Open' AS Status

FROM DataSource;

Concatenate(Data)

LOAD

id,

closed AS Date,

'Day' & Day(closed) AS Day,

'Close' AS Status

FROM DataSource;

Now in chart simply try like this

Chart : Line Chart

Dimension: Day, Status

Expression: Count(Status)

Hope this helps you.

Regards,

Jagan.