topic Re: Commulative Stock in QlikView

Commulative Stock

Mon, 01 Sep 2014 04:25:24 GMT

Hi Friends,

I have three fields like below table for year 2010-11

Projects	Opening Stock	Closing Stock	Month
A	100	120	Apr
A	120	160	May
A	160	200	Jun
A	200	210	Jul
A	210	230	Aug
A	230	280	Sep
A	280	300	Oct
A	300	350	Nov
A	350	360	Dec
A	360	390	Jan
A	390	400	Feb
A	400	500	Mar

my requirement is to find Total Opening Stock for the Year and Closing stock cumulative for all projects. There are three projects A,B and C. the table only showing A.There are data available for B and C in the same format. Does anyone has any Idea how to solve this query.

Regards

Bhawna

Re: Commulative Stock

senarath — Mon, 01 Sep 2014 04:36:07 GMT

Hi,

You may have to attach data sample for expert advice from anybody.

However, Please check data model preview and see whether you have uploaded data for B and C. If you have supressed null values in Dim, you normaly get this situation.

thanx

Re: Commulative Stock

Mon, 01 Sep 2014 05:10:04 GMT

use following expression for the cumulative sum

(above(sum(Close_Stock),0,RowNo()))

Projects	Opening Stock	Closing Stock	Month
A	100	120	Apr
A	120	160	May
A	160	200	Jun
A	200	210	Jul
A	210	230	Aug
A	230	280	Sep
A	280	300	Oct
A	300	350	Nov
A	350	360	Dec
A	360	390	Jan
A	390	400	Feb
A	400	500	Mar

Projects	Opening Stock	Closing Stock	Month
A	100	120	Apr
A	120	160	May
A	160	200	Jun
A	200	210	Jul
A	210	230	Aug
A	230	280	Sep
A	280	300	Oct
A	300	350	Nov
A	350	360	Dec
A	360	390	Jan
A	390	400	Feb
A	400	500	Mar

Projects	Opening Stock	Closing Stock	Month
A	100	120	Apr
A	120	160	May
A	160	200	Jun
A	200	210	Jul
A	210	230	Aug
A	230	280	Sep
A	280	300	Oct
A	300	350	Nov
A	350	360	Dec
A	360	390	Jan
A	390	400	Feb
A	400	500	Mar