Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

amit_saini
Honored Contributor 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
Esteemed Contributor II

Re: Average in Line Charts Issue

not sure,but try

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

1 Reply
vinieme12
Esteemed Contributor II

Re: Average in Line Charts Issue

not sure,but try

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