Average in Line Charts Issue

amit_saini — Fri, 03 Feb 2017 07:44:36 GMT

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,

Re: Average in Line Charts Issue

vinieme12 — Fri, 03 Feb 2017 07:54:22 GMT

not sure,but try

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

topic Average in Line Charts Issue in QlikView

Average in Line Charts Issue

Re: Average in Line Charts Issue