topic Re: Convert number values into time in QlikView

Convert number values into time

Tue, 20 Oct 2015 10:17:01 GMT

Hello,

This is a re-post as I may have not been very clear in the original!

I have a simple x/y graph and need to display the actual time seen in the data source (See attached). At the moment, all I'm seeing is a 5 minutes interval scale. I've tried using =Time(Time,'hh:mm') but this does not make any difference.

I've seen this issue in excel sometimes and usually, the numbers can be converted by checking the format or applying some thing alongh the lines of =TIME(LEFT(A1,2),RIGHT(A1,2),)

For the Dimension I have:

=Time(Time,‘hh:mm’)

For the Expression I have :

The condition is

max({State1}Time)>0

The definition is

avg({$<
[Field1]=State1::[Field1a],
      [Field2]=State1::[Field2],
               [Field3] =State1::[ Field3],
                     Field4=State1:: Field4
>}Results)

I cannot share the file for privacy reasons however can provide any details required to help.

Re: Convert number values into time

Tue, 20 Oct 2015 10:55:40 GMT

Hi Mike,

Can you send one value of row as example or specify the mask of your date?

Re: Convert number values into time

swuehl — Tue, 20 Oct 2015 11:00:08 GMT

You are using a continuous x-axis, right?

Have you tried changing the cont. axis format to Time on Number tab of chart properties?

Re: Convert number values into time

rubenmarin — Tue, 20 Oct 2015 11:03:37 GMT

In the png seems than Time has values like 0.90 ¿Wich time is this? ¿90 minutes or 54 minutes (90% of an hour)?

As Marcos saids, we'll need a sample to check the values, dates are tricky, you see one thing but you can't know the number behind that string (if there is one, and it should be to really be a time or date).

If 0.90 means 90 minutes you can try to change your dimension to:

=Time(Interval#(Time, 'h.mm'))

Re: Convert number values into time

miguelbraga — Tue, 20 Oct 2015 11:04:04 GMT

Hi Mike,

You can make your field time by doing this:

Time(maketime( Left(A1,2), RIGHT(A1,2)), 'hh:mm') as Time

if A1 is something like this: '09:30'.

And then use this field as your dimension and in your expression

Re: Convert number values into time

Tue, 20 Oct 2015 12:21:28 GMT

Sometimes it's the simplest things we miss.

Thanks very much!