Qlik Sense - Time : Conversion / Bucket / Class Issue

pdoray — Sat, 16 Nov 2024 20:19:06 GMT

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,

topic Qlik Sense - Time : Conversion / Bucket / Class Issue in App Development