Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Time converting to date in graph problem

Hi All,

I am tyring to make a graph of time vs date. My time expression is calculating the correct value which is showing when i sleect only 1 date.

However, when all data is displayed, the graph shows a date value instead of time.

please help...

Thanks!

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

Time() is a formatting function only, so time(END_TIME) = END_TIME, which includes the date.  When you have only one date, it seems to recognize your display format for the axis, even if the underlying value is still very large.  But when you have multiple dates, the times do not have the same underlying value, so it is unable to use your display format sensibly.  You can use time(frac(END_TIME)) to remove the date, but it STILL seems to get confused when you have multiple dates, resorting to displaying the time as a fraction of a day.  Interestingly, if you change it back to a linear scale instead of a log scale, it displays properly.  So I guess it's some problem with the log scale axis recognizing the time as a time.  If practical, using a linear scale axis combined with time(frac(END_TIME)) appears to solve the problem.

View solution in original post

2 Replies
johnw
Champion III
Champion III

Time() is a formatting function only, so time(END_TIME) = END_TIME, which includes the date.  When you have only one date, it seems to recognize your display format for the axis, even if the underlying value is still very large.  But when you have multiple dates, the times do not have the same underlying value, so it is unable to use your display format sensibly.  You can use time(frac(END_TIME)) to remove the date, but it STILL seems to get confused when you have multiple dates, resorting to displaying the time as a fraction of a day.  Interestingly, if you change it back to a linear scale instead of a log scale, it displays properly.  So I guess it's some problem with the log scale axis recognizing the time as a time.  If practical, using a linear scale axis combined with time(frac(END_TIME)) appears to solve the problem.

Not applicable
Author

Thanks so much John! I really appreciate ur timely response and detailed analysis iwth explanation. Thanks once again!