topic Re: KPI Calculation in App Development

KPI Calculation

jorditorras — Wed, 22 Nov 2017 11:05:05 GMT

Dear Gurús,

I have a table as follows:

And I have to make a calculation as follows:

( (Date_Time) - (Previous Date_Time) ) * Rolling Time

I've found a way for this calculation but in some cases some record is not picking the correct Previuos Date_Time.

Can anyone suggest a way for this calculation? This can be done in the script or in QlikSense Application.

Thanks in advance!!

Regards,

Jordi

sunny_talwar — Wed, 22 Nov 2017 13:00:31 GMT

Looking to do this in script or front end?

Ricardo_Gerhard — Wed, 22 Nov 2017 13:16:39 GMT

Dear Jordi,

You can use the function Above on chart options and Previous (script)

jorditorras — Wed, 22 Nov 2017 14:37:23 GMT

Both possibilities would be fine.

Thanks,

Jordi

sunny_talwar — Wed, 22 Nov 2017 15:37:57 GMT

The final output is needed in a chart or a KPI object?

jorditorras — Wed, 22 Nov 2017 16:17:58 GMT

For a KPI object.