topic Re: Display the TimeStamp in QlikView

Display the TimeStamp

anuradhaa — Thu, 20 Sep 2012 09:13:50 GMT

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

Re: Display the TimeStamp

martinpohl — Thu, 20 Sep 2012 09:18:43 GMT

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

Re: Display the TimeStamp

anuradhaa — Thu, 20 Sep 2012 09:25:30 GMT

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?

Re: Display the TimeStamp

anuradhaa — Thu, 20 Sep 2012 09:28:55 GMT

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

Please tell me how to do this?

Re: Display the TimeStamp

martinpohl — Thu, 20 Sep 2012 09:31:46 GMT

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

Re: Display the TimeStamp

anuradhaa — Thu, 20 Sep 2012 09:47:28 GMT

Please help me to solve me 1st question

Re: Display the TimeStamp

martinpohl — Thu, 20 Sep 2012 10:15:01 GMT

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

So just load the time from the timestamp value

Re: Display the TimeStamp

anuradhaa — Thu, 20 Sep 2012 10:57:00 GMT

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

i want to use the value only upto minutes