Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
mahnoor1279
Contributor III
Contributor III

How to calculate average of three values

I want to calculate the average of these three expressions to show in KPI and also in the table for each customers.

 

if(isnull(REVIEWED_DATE),TODAY()- ENTER_DATE,REVIEWED_DATE - ENTER_DATE)

+
if(not isnull(ACCT_REJECT_DATE),ACCT_REJECT_DATE - REVIEWED_DATE,Today() - REVIEWED_DATE)

+
IF(Status ='PROCEED',(ACCT_OPEN_DATE - LOG_SHEET_DATE))

Labels (3)
1 Reply
TcnCunha_M
Creator II
Creator II

My suggestion
Move this to script

than you sum everything and split for 3 ?

if prefer to keep this expression:

(

if(isnull(REVIEWED_DATE),TODAY()- ENTER_DATE,REVIEWED_DATE - ENTER_DATE)

+
if(not isnull(ACCT_REJECT_DATE),ACCT_REJECT_DATE - REVIEWED_DATE,Today() - REVIEWED_DATE)

+
IF(Status ='PROCEED',(ACCT_OPEN_DATE - LOG_SHEET_DATE))

)/3

As you think, so shall you become.