topic Re: Calculation of Stock in QlikView

Calculation of Stock

Fri, 07 Jun 2013 11:14:51 GMT

Hi all,

If I have data like the attached example, how do I create a column

with the value of Stock for each day.

For Example:

DayOrder In Out Stock

01/01/2004 120 10 110

04/01/2004 50 20 140

07/01/2004 10 130

13/01/2004 80 30 180

20/02/2004 20 15 185

20/01/2004 16 201

Thank All

giakoum — Fri, 07 Jun 2013 11:20:01 GMT

you can use the above function in charts or the previous function in the reload script to achieve this.

Fri, 07 Jun 2013 11:31:32 GMT

Hi Ioannis,

Can you send me an example or a link because

I dont know how to do a for ... next cycle or something like that?

Thank

er_mohit — Fri, 07 Jun 2013 11:41:40 GMT

See the attached file

giakoum — Fri, 07 Jun 2013 11:58:03 GMT

see attached example

Sokkorn — Sun, 09 Jun 2013 05:01:38 GMT

Hi,

Create Strainght Table with

Dimension

. DayOrder

Expression

. In = Sum(In)

. Out = Sum(Out)

. Stock = RangeSum(Above(Total (Sum(In)-Sum(Out)),0,RowNo(Total)))

Regards,

Sokkorn