Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

trending fuel consumption of fleet

Hi,

We have a fleet consisting of several trucks and we want to the monitor fuel consumption of individual trucks. At every fuel intake we register:

* date

* time

* current milage

* quantity of fuel

* license plate

I'm not sure how to determine all increments, so we can trend fuel consumption. My ultimate goal is:

*  to find out which trucks have the highest fuel consumption /milage within a certain period.

* to identify trucks with a steadily increasing fuel consumption/milage

Can anyone give me some tips and tricks?

Thanks in advance

Per

Community Browser