Qlik Sense - Time : Conversion / Bucket / Class Issue

[pdoray]

Hi Qlik Community,

I’m facing a weird behaviour regarding the class function & time zone conversion (.qvf & data attached): 

Issue explanation :

when using class Function with time zone conversion based on variable switch (UTC / LOCAL), the class affected  to time buckets differs:

For UTC, time @ 18h00 is affected to lower class (17h45 to 18h00) where the local conversion (@03:30)  affects the row to upper class (03:30 to 03:45)

• I’ve tried to use interval function instead of class with floor or round function but couldn’t find the solution so far..

Is there a trick to handle the affectation ?  Any workaround to propose ?

Best Regards,