topic Re: average sales in QlikView

average sales

sagaraperera — Thu, 01 Oct 2015 09:11:36 GMT

Dear All

my table include a sales figure month wise. i want a avarage sales figure in a one column. please help.

my script

SALES:

LOAD BCOD,

CLA_CODE,

PRD_CODE,

POLICY_NO,

REF_NO,

DATE(floor(MARKETING_DATE)) as MARKETING_DATE,

//DATE(monthstart(MARKETING_DATE), 'MM-YYYY') as MonthYear,

MDATE,

YEAR,

MONTH,

NAME,

ME_CODE,

//TRN_DATE,

DATE(floor(TRN_DATE)) as TRN_DATE,

TRAN_YEAR,

TRAN_MONTH,

POL_PERIOD_FROM,

SCCOD,

IF(SCCOD>='SC0','COUNTER')AS CITY_COUNTER,

CP,

RS,

TC,

GROSSTOT,

TYPE,

N_R_NOS1,

F_NOS2

FROM

G:\qlickviwe\Sales\SALES2012.QVD

(qvd);

Re: average sales

stephenedberkg — Thu, 01 Oct 2015 09:18:43 GMT

avg(aggr(sum(sales),month))

Re: average sales

MK_QSL — Thu, 01 Oct 2015 09:33:34 GMT

Which field is showing Sales figure?

You can use something like below

Avg(Aggr(SUM(YourSalesField),MONTH))

Re: average sales

krishna20 — Thu, 01 Oct 2015 10:22:47 GMT

Hi,

Refer this link, It may helps.

Calculate average pr month

Re: average sales

gautik92 — Thu, 01 Oct 2015 10:24:12 GMT

avg(aggr(sum(sales),MonthField))