Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Max Time on X Axis

Hi

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?

Untitled.png

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

Thanks

3 Replies
MK_QSL
MVP
MVP

Provide sample app.

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
MarcoWedel

Hi,

maybe one solution could be:

QlikCommunity_Thread_266294_Pic1.JPG

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