topic Re: Date wise average base on ID in QlikView

Date wise average base on ID

iahmadmca1 — Fri, 14 Apr 2017 16:32:09 GMT

Team,

Just want to ask one requirement based on date wise average.we have date column AM and PM I want to average of 11/21/2016 AM and 11/21/2017 PM.

Let's consider 11/21/2016 AM as (A) and 11/21/2017 as (B).I want to average each every day based on AMITGBID.could you please help me to do this.As for example

1.avg=(B-A/A). I want to calculate the average based on AMITGBID

Thanks,

Irshad Ahmad

Re: Date wise average base on ID

Anil_Babu_Samineni — Fri, 14 Apr 2017 17:11:12 GMT

I am not following you, You mentioned A & B and then Avg of A-B. Till this is okay for me. What are the dates you have. Would you share sample to work on it and try to explain expected result also

Re: Date wise average base on ID

iahmadmca1 — Fri, 14 Apr 2017 17:28:50 GMT

Thank for the response Anil, Write now I have only 11/21/2016 AM and 11/21/2017 PM. Based on this date I want to calculate the average.

The expected result will be.

A=30518 and B=28484 and AMITGBID=1922 then.

avgresult=28484-30518/30518;

Thanks,

Irshad Ahmad

Re: Date wise average base on ID

Anil_Babu_Samineni — Fri, 14 Apr 2017 17:31:32 GMT

A=30518 and B=28484 and AMITGBID=1922 then.

How you are getting these values, That is my question? There is no data points available

Re: Date wise average base on ID

iahmadmca1 — Fri, 14 Apr 2017 17:45:51 GMT

I request to you please refer the article which is uploaded.

let's see once again.

AMITGB ID 11/21/2016 AM 11/21/2017 PM

-----------------------------------------------------------------------

1922 30518 28484

3765 26083 25642

1807 18996 19939

Like this, i have data set.