topic Re: Line Chart with Trend in App Development

Line Chart with Trend

AtQlik — Tue, 13 Oct 2020 22:06:30 GMT

Hi,

I am developing a line chart which has duration as xaxis and date + Time in which a task was executed. Something like below.

Date	Time executed	Duration(mm:ss)
10/05	10 AM	1:10
10/06	10:30 AM	2:35

I am trying to develop a chart similar to the one shown in the image. I am facing challenges fixing the x-axis. Could you pls help me with the steps to display the line chart something like below one. The data which I am using is similar to what shown in the above table.

Re: Line Chart with Trend

Delestia — Wed, 14 Oct 2020 00:34:30 GMT

Hello Qlikatmap,

This can be achieved by using the Line Chart element on your desired sheet. For the first Group Dimension choose your [Time Executed] field in order to get the date time as the x-axis. Then for the Individual Line Dimension choose your [Date] field to get a line for each date you executed the experiment. Finally for your measure, I chose to use Sum([Duration]) however Min/Max will also produce the correct line depending on your data.

Re: Line Chart with Trend

AtQlik — Wed, 14 Oct 2020 02:11:16 GMT

Thank you Delestia for your reply.

For your kind reference sharing below visual. the Time for x-axis is not getting fixed and not ordered. I have marked in red arrow. 9 am for 5th October and 10 October is sequential lined up rather it is order by date. Is there a way to fix the x- axis as 8AM to 8 PM with 1 hr interval. Also the wave lines for different dates are not overlapping rather it is getting displayed next to it.

Re: Line Chart with Trend

AtQlik — Wed, 14 Oct 2020 02:20:07 GMT

Below is the script I am using to load the data from excel file.

[Created] as [Actual Date], --- ex: 10/8/2020 4:47:00 PM
Date([Created],'DD/MM/YYYY') AS cDate, -- date field separated from previous row [Created]
Time([Created],'hh:mm TT') as ccTime, -- time field separated from previous row [Created]
Time([Elapsed time],'mm:ss') as [Time Taken], -- duration in minutes and secs