Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Calculate average of differences

I have a column of data called [Staff Timesheet Hours from Microix.Billed Hours]. I am calculating the difference from one row to the next with the following expression:

FABS(([Staff Timesheet Hours from Microix.Billed Hours])-Above([Staff Timesheet Hours from Microix.Billed Hours]))

This works correctly. Now I want to calculate the average of the differences (the average of the expression).

Any help would be appreciated. Thanks in advance.

Labels (1)
0 Replies