topic Re: Re: Mean Help in QlikView

Mean Help

ajaykumar1 — Fri, 26 Sep 2014 07:31:15 GMT

Hi All,

I have the data week wise and the same has been arranged in horizontal way as per the attachment.

The expression which I have written is Sum(Quan1)/Sum(Quan2).

Now I want to calculate the mean.

Type Week 37 38 39 Total Mean Profile37 Profile38

A 5 10 15 30 10(i.e. 30/3) 0.5 (i.e. abs(5-10)/10 0 (i.e. abs(10-10)/10)

For Type B,C,D also same logics i have to apply.

Please help the same.

Thanks ,

Ajay

anbu1984 — Fri, 26 Sep 2014 07:43:12 GMT

Mean = Total / Count(Week)

ajaykumar1 — Fri, 26 Sep 2014 09:00:17 GMT

Thanks...But not working and even getting error when am tried total keyword also dont know why.

Any help from others also.

Thanks,

Ajay

anbu1984 — Fri, 26 Sep 2014 09:17:41 GMT

I meant Total expression you shown above. If you still have issues, post your sample qvw

ajaykumar1 — Fri, 26 Sep 2014 10:10:57 GMT

Hi,

Please find the sample data as well as the required output.

Let me know if in case of anything required.

Thanks,

Ajay

ajaykumar1 — Fri, 26 Sep 2014 10:42:25 GMT

Any hint from anyone.

Thanks,

Ajay

ajaykumar1 — Fri, 26 Sep 2014 13:49:49 GMT

Any help...

Many thanks,

Ajay

anbu1984 — Fri, 26 Sep 2014 13:59:40 GMT

Can you provide qvw which you tried