Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need to show actual time as seen in the source data

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?

4 Replies
gautik92
Specialist III
Specialist III

share sample qvw

raghvendrasingh
Creator II
Creator II

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

avinashelite

What is the interval required ?

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

Not applicable
Author

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)