Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

anuradhaa
Not applicable

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
Not applicable

Re: Display the TimeStamp

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
Not applicable

Re: Display the TimeStamp

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
Not applicable

Re: Display the TimeStamp

"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
Not applicable

Re: Display the TimeStamp

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
Not applicable

Re: Display the TimeStamp

Please help me to solve me 1st question

martinpohl
Not applicable

Re: Display the TimeStamp

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

So just load the time from the timestamp value

anuradhaa
Not applicable

Re: Display the TimeStamp

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

i want to use the value only upto minutes