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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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

Labels (1)
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