topic need help in QlikView

need help

mshailaja — Wed, 25 Nov 2020 16:16:04 GMT

i have start date and en date as below, i want to show the difference between those two dates in minutes in script level, below is the

sample data. can anyone help pleasee

i want to show the diffrenece in minutes.

adamdavi3s — Thu, 09 Mar 2017 09:29:50 GMT

interval(startdate - enddate,'mm')

tamilarasu — Thu, 09 Mar 2017 09:46:20 GMT

Adam,

I hope you meant the below one.

Interval(enddate- startdate,'mm')

adamdavi3s — Thu, 09 Mar 2017 09:47:52 GMT

haha yes, my mistake!

tamilarasu — Thu, 09 Mar 2017 09:48:26 GMT

mshailaja — Fri, 10 Mar 2017 11:46:21 GMT

I have tickets which are in opendate, i want to do analysis about the tickets which are in open state lik below screen shot

and i want the report like this

Anyone please help

mshailaja — Fri, 10 Mar 2017 11:52:20 GMT

I am working in the server,if i am keeping in the interval function , i a m getting like this

, secondsit is directly coming from the database. i want to show in minutes.please help..

Anonymous — Fri, 10 Mar 2017 12:23:27 GMT

hi,

Maybe this:

num#(Interval(timestamp#(timestamp(enddate,'YYYY-MM-DD hh:mm:ss'),'YYYY-MM-DD hh:mm:ss')

-timestamp#(timestamp(startdate,'YYYY-MM-DD hh:mm:ss'),'YYYY-MM-DD hh:mm:ss')

,'m')) as CompletedTimeMinutes

tamilarasu — Fri, 10 Mar 2017 12:39:32 GMT

Hi,

Have a look at the attached file. It's working fine.

hemachandran — Fri, 10 Mar 2017 12:55:32 GMT

Hi.

can u try this...

=Interval(Date(date#(startdate,'DD/MM/YYYY hh:mm:ss TT'),'MM')-Date(date#(Enddate,'DD/MM/YYYY hh:mm:ss TT'),'MM'),'MM')