Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mhmmd_srf
Creator II
Creator II

How to change the range in X axis

Hi All,

I have a chart where Time is in X axis. Time is hh:mm TT format. We want to display the X axis in 15 mins interval though database is capturing data in every minutes.

Could you please help on this.

Thanks,

Sarif

1 Solution

Accepted Solutions
brunobertels
Master
Master

Hi

Try this may be

timestamp(ceil("Time",1/96),'hh:mm') as 15minInterval,

Bruno

View solution in original post

6 Replies
shraddha_g
Partner - Master III
Partner - Master III

I don't think it is possible.

As of now you can only define min and max value for axis.

brunobertels
Master
Master

Hi

Try this may be

timestamp(ceil("Time",1/96),'hh:mm') as 15minInterval,

Bruno

mhmmd_srf
Creator II
Creator II
Author

wow...thats great..it working thanks a lot... what should be logic if I make it 5 mins interval?

Could you please explain the logic as well

Regards,

Sarif

brunobertels
Master
Master

HI

=timestamp(ceil("Date",1/288),'YYYY-MM-DD hh:mm') FOR 5 MM

as there is 288 x 5 mm in 24 hours

or there is 96 x 15 mm in 24 hours

Ragards

Bruno

mhmmd_srf
Creator II
Creator II
Author

Hi Bruno,

I am facing an issue while implementing the 5 mins interval.The first 4 intervals are showing erratically in the x axis.again they are adding up 15 mins instead of 5 in the rest. Can you please help.

brunobertels
Master
Master

Hi

Are you sure there is data between interval 00:05 and 00:20 ?

Bruno