topic Time converting to date in graph problem in QlikView

Time converting to date in graph problem

Tue, 09 Aug 2011 22:09:27 GMT

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!

Time converting to date in graph problem

johnw — Tue, 09 Aug 2011 22:26:57 GMT

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.

Time converting to date in graph problem

Wed, 10 Aug 2011 02:53:54 GMT

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