Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amit_saini
Master III
Master III

Average in Line Charts Issue

Hi Folks,

I'm having below line charts :

Dimension: Month

Expression:

Supplier:

=Avg({<Defect_Imediate_Action={'LeadTime'},Complaint_Type_Description={'Supplier'}>} num((if(IsNull(if(Finished_Date < 2958465, date(Finished_Date))),

floor(Networkdays(date(%DATE_Key),(today()))),

floor(

   (if(Finished_Date < 2958465, Networkdays(date(%DATE_Key),date(Finished_Date))))

  )

))))

Kautex:

=Avg({<Defect_Imediate_Action={'LeadTime'},Complaint_Type_Description={'Supplier'}>} num((if(IsNull(if(Closure_Date < 2958465, date(Closure_Date))),

floor(Networkdays(date(%DATE_Key),(today()))),

floor(

   (if(Closure_Date < 2958465, Networkdays(date(%DATE_Key),date(Closure_Date))))

  )

))))

Issue: Now I have to create one more expression "Overall" which should be average of these 2 expressions.

So I'm trying simple =sum(Column(1)+Column(2))/Count(Column(1)+Column(2)) ,but it's not showing any result.

Please help me out , what could be the best expression to calculate average of "Supplier" and "kautex".


Thanks,

AS

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

not sure,but try

RangeAvg(column(1),Column(2))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

1 Reply
vinieme12
Champion III
Champion III

not sure,but try

RangeAvg(column(1),Column(2))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.