topic Re: X Axis formatting for Time in QlikView

X Axis formatting for Time

samuel_brierley — Tue, 15 Apr 2014 08:02:54 GMT

Hi All,

Im using QlikVIew to analyse data logs, so changing their format isnt possible which i think is leading to my issue.

on the X axis I have Time and on the Y some average function (Doesnt matter yet).

What Im after on the X axis is show time thats all, when I click the continuous option QlikView seems to convert the time to a fraction of a day which isnt really very good, ideally it would show every hour but when i zoom in shows minutes or something along them lines.

I have attached the file so you can have a play and see where im coming from.

thanks

https://www.dropbox.com/s/vopal1gr2sj6cc7/stss%208.qvw

Re: X Axis formatting for Time

maxgro — Tue, 15 Apr 2014 20:23:36 GMT

try formatting in tab number the continous x-axis as time with format hh:mm:ss

then in axis tab, set label vertical

hope it helps

Re: X Axis formatting for Time

Tue, 15 Apr 2014 22:02:57 GMT

If you want to get the format 'hh:mm'. Go to Edit script and change time format to 'hh:mm'. Attached is the place where you can change it from 'hh:mm:ss' to 'hh:mm'. Hope this helps.

Suraj

Re: X Axis formatting for Time

Mon, 18 May 2015 20:37:25 GMT

I am creating a stacked combo chart with a continuous X axis, but I am having trouble with the data representation. When I see the full char the dates are correctly formatted:

I am used the following in the load script:

LOAD
CallCenterCount,
DATE(CallCenterDate,'MM/DD/YYYY') AS [CallCenterDate],
CallCenterMonthNum,
CallCenterType,
CallCenterYear;

However, when I zoom in on one date in the chart, the information changes to being formatted a number:

I have tried several things, but I have been unsuccessful in trying to keep the date formatted as MM/DD/YYYY. Any help would be great!