Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rukhsark
New Contributor

How can i display the total time take/ avg time taken in bar chart report

Hi,

I have an EOD process that is run everyday for a number of steps, say 10 steps per day.

i store the start_time and end_time for every step in my EOD_process table.

i want to create a report in Qlik sense which will display the total time taken/average time taken for a step to execute a particular day.

i am not able to achive this in my bar chart as well as line chart report.

Can somebody help me with this?

Query to load data –

select STEP_NAME,

CREATED_DATE,

START_TIME,

END_TIME,

extract( hour from (END_TIME-START_TIME) ) ||'.'||extract( minute from (END_TIME-START_TIME) ) AS "DIFF"

from EOD_process;

bar_Chart.jpg

1 Solution

Accepted Solutions
MVP
MVP

Re: How can i display the total time take/ avg time taken in bar chart report

Is it something like this you had in mind?

2018-01-24 23_28_49-Qlik Sense Desktop.png

2 Replies
MVP
MVP

Re: How can i display the total time take/ avg time taken in bar chart report

Is it something like this you had in mind?

2018-01-24 23_28_49-Qlik Sense Desktop.png

rukhsark
New Contributor

Re: How can i display the total time take/ avg time taken in bar chart report

Yes i wanted something like this.

Thanks Petter, your app helped me a lot

Community Browser