topic Re: Max Time on X Axis in QlikView

Max Time on X Axis

Wed, 25 Nov 2020 16:16:04 GMT

I have a chart which displays the time on the X axis from 00:00 to 24:00.

If data flows slightly over 24:00, the next bar on the axis appears as 30:00

Instead of 30:00 is it possible to show 06:00 instead?

What could be put in the Axes Static Max box to achieve this?

Thanks

MK_QSL — Mon, 03 Jul 2017 14:08:22 GMT

Provide sample app.

Anil_Babu_Samineni — Mon, 03 Jul 2017 14:10:09 GMT

I assume, Your Format need to change as 12 hours rather 24 hours?

MarcoWedel — Tue, 04 Jul 2017 21:54:46 GMT

Hi,

maybe one solution could be:

LOAD RecNo() as ID,
    Time(Floor(Rand()*1.3,'01:00'),'hh:mm') as X,
    Ceil(Rand()*100) as Value
AutoGenerate 20;

hope this helps

regards

Marco