Want Expression to get average closing value

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I attached my sample data and i want to get avg closing value for selected date from my source Table data.

i used this below expression but not work

num((((sum({1<DOCDATE=$::DOCDATE,

DOCDATE = {"$(01/04/2018)"},

MOVEMENT={'1'}

>}STOCK))

(sum({1<DOCDATE=$::DOCDATE,

DOCDATE = {">$(01/04/2018)<$(vFromDate)"},

MOVEMENT={'1'}

//DOCDATE = {'$(vFromDate)'}

>}STOCK)))

(sum({1<DOCDATE=$::DOCDATE,

DOCDATE = {">$(01/04/2018)<$(vFromDate)"},

MOVEMENT -= {'1'}

>}STOCK)))

Count(DISTINCT{1<DOCDATE=$::DOCDATE,

DOCDATE = {">$(01/04/2018)<=$(vFromDate)"}>}DOCDATE)

(sum({1<DOCDATE=$::DOCDATE,

DOCDATE = {">=$(vFromDate)<=$(vToDate)"},

MOVEMENT={'1'}

>}STOCK)

sum({1<DOCDATE=$::DOCDATE,

DOCDATE = {">=$(vFromDate)<=$(vToDate)"},

MOVEMENT={'-1'}

>}STOCK))

/Count(DISTINCT DOCDATE)

,'##0')

Thanks advance

Sasikumar

topic Want Expression to get average closing value in QlikView