How to calculate average time in hrs between start Date and End Date?
I am new to QlikView, and trying to create a bar chart which shows average execution time in hrs for cases opened between Start Date and End Date.If a Case is completed then the end date will be populated by the app otherwise it will be blank (system time need to be taken into consideration)
X Axis --> would give the Open and complete case
y axis --> Average Time in hrs
Tried using the below formula for calculating the average time but no graph is displayed