topic Re: time format in QlikView

time format

Anonymous — Tue, 12 Jan 2016 04:39:48 GMT

hi,

i have feild like this 1.30 , 1.28 - that represents time.

i'm using that function -- Time(Sum(time#((Cat00), 'hh.mm')),'hh.mm') to calculte time.

the nimber at the pivot proporties is interval.

when the number is 1.30 which means 1 hour & 30 minute i get 1.03 = 1 hour & 3 minute.

when the number is 1.28 i get yhe right number 1 hour & 28 minute.

what is wrong ?

thanks'

yarin.

Re: time format

sunny_talwar — Tue, 12 Jan 2016 04:42:55 GMT

Try this:

=Time(Time#(Num#('1.30', '#.##'), 'h.mm'), 'h:mm')

Replace '1.30' with yout Time Field.

Re: time format

Anonymous — Tue, 12 Jan 2016 04:48:46 GMT

thanks'

but it's still the same

Re: time format

sunny_talwar — Tue, 12 Jan 2016 04:54:20 GMT

It seems to be working here:

Re: time format

tamilarasu — Tue, 12 Jan 2016 04:59:23 GMT

Try,

=Time(Time#('1.30', 'hh.mm'),'h:mm')

Re: time format

Anonymous — Tue, 12 Jan 2016 05:04:34 GMT

try 1.3 not 1.30

Re: time format

sunny_talwar — Tue, 12 Jan 2016 05:07:46 GMT

Try this:

=Time(Time#(Num(Num#('1.3', '#.#'), '#.00'), 'h.mm'), 'h:mm')

Re: time format

Anonymous — Tue, 12 Jan 2016 05:20:46 GMT

now it's look o.k. but where i need to write "sum" ?

Re: time format

sunny_talwar — Tue, 12 Jan 2016 05:23:38 GMT

With regards to Sum, what exactly are you doing? Not really sure

Re: time format

Anonymous — Tue, 12 Jan 2016 05:27:46 GMT

it's o.k. .

thank you very much.

Re: time format

jagan — Tue, 12 Jan 2016 05:33:44 GMT

Hi,

Try like this

Time:

LOAD

Time(Time#(Num(Num#(TimeStamp, '#.#'), '#.00'), 'h.mm'), 'h:mm') AS TimeStamp,

(Subfield(TimeStamp) * 60) + (Subfield(TimeStamp, 2)) AS Minutes

INLINE [

TimeStamp

1.3

2.3

2.0];

Now in charts or text object use

=Div(Sum(Minutes), 60) & ':' & Mod(Sum(Minutes), 60)

Hope this helps you.

Regards,

Jagan.