Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
anuradhaa
Partner - Creator II
Partner - Creator II

Display the TimeStamp

Dear all,

I have a table which have time values, the data typa is TIMESTAMP(6).

So i need to get that data in Line Chart.

Data is chainging every 5 mins, so need to consider mins also.

Please tell me how can i simplified this.

another one thing,

I have created a line chart using all raw TIME data,

Then it has lot of data in x axsis,

Can i use Scorall Bar here?

Please tell me how to do it,

Display only 10 values and then scorall bar

Thanks

7 Replies
martinpohl
Partner - Master
Partner - Master

for the second point:

on the properties of your chart, go to tab presentation, on the right site you can set the limits.

Unfortunatly in QV 11 you have to change the default 10 first that they will works (bug).

For the first question:

how are the timestamps are stored (format)?

Regards

anuradhaa
Partner - Creator II
Partner - Creator II
Author

Thanks for your reply,

This is the example of my data

20-SEP-12 04.43.08.361702000 AM

In your 2nd answer,

Can i use scorall bar in 11?

anuradhaa
Partner - Creator II
Partner - Creator II
Author

"Unfortunatly in QV 11 you have to change the default 10 first that they will works (bug)"

Please tell me how to do this?

martinpohl
Partner - Master
Partner - Master

check the scroll on x-axis.

Change the maximum numbers from 10 to 10 (I know it sounds stupid but you have to)

Then it will works

anuradhaa
Partner - Creator II
Partner - Creator II
Author

Please help me to solve me 1st question

martinpohl
Partner - Master
Partner - Master

Do you want ro show the values independent of the date?

So just load the time from the timestamp value

anuradhaa
Partner - Creator II
Partner - Creator II
Author

No, i want to use thos etime value with other data,

i want to use the value only upto minutes