Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More

Qlik Sense - Time : Conversion / Bucket / Class Issue

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)Issue Screenshot.png

  • 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,

Labels (2)