topic Re: Need to show actual time as seen in the source data in QlikView

Need to show actual time as seen in the source data

Wed, 14 Oct 2015 09:39:28 GMT

Hello,

I have a simple x/y graph and need to display the actual time seen in the data source. 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. See attached. Any ideas please?

Re: Need to show actual time as seen in the source data

gautik92 — Wed, 14 Oct 2015 09:41:10 GMT

share sample qvw

Re: Need to show actual time as seen in the source data

raghvendrasingh — Wed, 14 Oct 2015 09:47:03 GMT

Hi,

Please share your field (i.e Time) with some values.

So that we can recognize,in which format time is coming.

then we can help you better.

Thanks,

Raghvendra

Re: Need to show actual time as seen in the source data

avinashelite — Wed, 14 Oct 2015 09:49:43 GMT

What is the interval required ?

if you want to create a interval you can use the Class function or interval match function

Re: Need to show actual time as seen in the source data

Wed, 14 Oct 2015 09:59:16 GMT

These are the details:-

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],
Field34=State1:: Field34
>}Results)