topic Problems with date in QlikView

Problems with date

Thu, 25 Mar 2010 10:00:21 GMT

Hi sorry for my bad english

i have a field that is numeric... i had to transform this to a time mode.

for example the number 65 is 1 hour and 5 minutes. So the pivot table msut show 1h 5min.

And also it has to make the SUM of all the times,,

is this posible ?? thanks.

Thu, 25 Mar 2010 10:05:00 GMT

Hi,

see the attached example for more help.

Good luck!

Rainer

Thu, 25 Mar 2010 10:23:38 GMT

this ok...

but another thing ..

inthe filed of the chart Proyect duration (days hours etc) how can it makes the sum

Thu, 25 Mar 2010 10:52:45 GMT

This is not possible here. The reason is it´s a alphanumeric field and not a number.

Rainer

Thu, 25 Mar 2010 11:10:54 GMT

Thanks.