Chart: Count reversed

[george55]

Hi all

In my linechart-object there are 1-hour buckets (accumulation of the events in 1 hour). It worked fine, that would like to have it reversed. E.g.:

02.12.2019 10:03:34

02.12.2019 10:03:57

02.12.2019 10:53:20

02.12.2019 10:59:11

Instead of counting 4 events in 10 a.m, it should count 4 events in 11 a.m. 

I could do it by creating a new timeseries with -1 hour, but would like to avoid this. Is there a smart possibility to do that? please find attached the app.

Thanks.

George

[jochem_zw]

you can use IntervalMatch function:
https://help.qlik.com/nl-NL/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...

[george55]

thanks. Did take a look. As I understood I would have more effort to implement than my workaround -1 hour. You must first create the invertalls manually and also implement it in the load editor.