Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mhmmd_srf
Contributor 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
Valued Contributor II

Re: How to change the range in X axis

Hi

Try this may be

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

Bruno

6 Replies
shraddha_g
Honored Contributor III

Re: How to change the range in X axis

I don't think it is possible.

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

brunobertels
Valued Contributor II

Re: How to change the range in X axis

Hi

Try this may be

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

Bruno

mhmmd_srf
Contributor II

Re: How to change the range in X axis

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
Valued Contributor II

Re: How to change the range in X axis

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
Contributor II

Re: How to change the range in X axis

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
Valued Contributor II

Re: How to change the range in X axis

Hi

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

Bruno