topic Re: How to make my average stock amount display correctly ? in QlikView

How to make my average stock amount display correctly ?

paulyeo11 — Sat, 28 Mar 2015 07:59:23 GMT

Hi All

When i select year = 2015 ,

How to make the average stock equal to 1,697 K ? Now it display 1,132 K when i set expression as average.

Kindly see my enclosed QV Doc.

Paul

Re: How to make my average stock amount display correctly ?

MK_QSL — Sat, 28 Mar 2015 09:04:41 GMT

You don't have any values for 15 March, so whatever you are getting is the right result but if you still want forcefully 1697, change your expressions as below

STOCK_OPEN

IF(sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} STK_OPEN/1000)>0,

sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} STK_OPEN/1000))

STOCK_CLOSE

IF(sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} STK_CLOSE/1000) > 0,

sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} STK_CLOSE/1000))

Re: How to make my average stock amount display correctly ?

paulyeo11 — Sat, 28 Mar 2015 18:06:57 GMT

Hi Sir

Thank you very much for your expression.

Paul