Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Change intervals on Y axis

I Have a Y axis in a line chart (or bar chart etc...) which is in half hour intervals e.g 9:30, 10:00, 10:30.... with measure values e.g 50, 120,65, 80....I want to compress the x-axis to be 9:00, 10:00, 11,00 etc and the values would be correspondingly 170, 135 etc... is this possible in Sense or do i need to modify source data?

MAny thanks

DEnis

6 Replies
Not applicable

Re: Change intervals on Y axis

‌mistake on my part. It's an X axis,

vinieme12
Esteemed Contributor II

Re: Change intervals on Y axis

please post a data sample

Not applicable

Re: Change intervals on Y axis

         This is representative data

MPANIDDateMonthYearYYYYMMMonthAbbrDayofWeekTimeSlotDayTimeValue
120005032874001/07/201507201520157JulWed00:30Wed 00:3046.6
120005032874001/07/201507201520157JulWed01:00Wed 01:0044.9
120005032874001/07/201507201520157JulWed01:30Wed 01:3044.2
120005032874001/07/201507201520157JulWed02:00Wed 02:0040.3
120005032874001/07/201507201520157JulWed02:30Wed 02:3029.2
120005032874001/07/201507201520157JulWed03:00Wed 03:0023.9
120005032874001/07/201507201520157JulWed03:30Wed 03:3024.5
120005032874001/07/201507201520157JulWed04:00Wed 04:0023.7
vinieme12
Esteemed Contributor II

Re: Change intervals on Y axis

Script:

Note: if you want to round down, replace Ceil() with Floor()

LOAD *,time(Ceil(Interval(TimeSlot,'hh:mm'),1/24),'hh:mm') as RoundedTime INLINE [

MPANID,Date,Month,Year,YYYYMM,MonthAbbr,DayofWeek,TimeSlot,DayTime,Value

1200050328740,01/07/2015,07,2015,20157,Jul,Wed,00:30,Wed 00:30,46.6

1200050328740,01/07/2015,07,2015,20157,Jul,Wed,01:00,Wed 01:00,44.9

1200050328740,01/07/2015,07,2015,20157,Jul,Wed,01:30,Wed 01:30,44.2

1200050328740,01/07/2015,07,2015,20157,Jul,Wed,02:00,Wed 02:00,40.3

1200050328740,01/07/2015,07,2015,20157,Jul,Wed,02:30,Wed 02:30,29.2

1200050328740,01/07/2015,07,2015,20157,Jul,Wed,03:00,Wed 03:00,23.9

1200050328740,01/07/2015,07,2015,20157,Jul,Wed,03:30,Wed 03:30,24.5

1200050328740,01/07/2015,07,2015,20157,Jul,Wed,04:00,Wed 04:00,23.7

];

RoundTime.JPG

Not applicable

Re: Change intervals on Y axis

Thanks Vineeth - almost right but on  X axis I'm still seeing the half hour slots rather than hour slots.

vinieme12
Esteemed Contributor II

Re: Change intervals on Y axis

can you attached sample app! as you can see it's working on the sample data