topic Re: remaining by rows in QlikView

remaining by rows

Mon, 05 May 2014 11:54:23 GMT

good afternoon,

could you help me to find solution about remaining by rows?

Example:

article despatch-date stock-lev sales

xxxx1 03/05/14 5000 1000

xxxx1 10/05/14 4000 500

xxxx1 11/05/14 3500 100

xxxx1 13/05/14 3400 500

xxxx1 15/05/14 2900 ........

where my stock-level is value (stock-lev, raw-1) - value (sales)

I hope it's all clear.

thanks for your help

Mauro

Re: remaining by rows

Mon, 05 May 2014 11:58:13 GMT

sorry,

could you write me a formula because I can't open file.qvd (in this moment).

Thanks

Mauro

Re: remaining by rows

anbu1984 — Mon, 05 May 2014 12:03:27 GMT

Can you show your input and explain how you derived your example data? What is raw?

What do you mean by value (stock-lev, raw-1)?

Re: remaining by rows

Mon, 05 May 2014 12:08:36 GMT

Hi Mauro Venzo,

Could you be more specific about your problem..

Thank you

Re: remaining by rows

tresB — Mon, 05 May 2014 12:13:52 GMT

Are you calculating the 'stock-lev' ? if so, then how do you get the first value '5000' ?

Re: remaining by rows

maxgro — Mon, 05 May 2014 12:22:38 GMT

let me try

source:

load * inline [

article , despatchdate , stocklev , sales

xxxx1 , 03/05/14 , 5000 , 1000

xxxx1 , 10/05/14 , 4000 , 500

xxxx1 , 11/05/14 , 3500 , 100

xxxx1 , 13/05/14 , 3400 , 500

xxxx1 , 15/05/14 , 2900 , .......

];

table:

NoConcatenate

load

article,

despatchdate,

stocklev,

sales,

if(peek(article)=article, peek(newstocklevel) - peek(sales), 5000) as newstocklevel

Resident

source

order by article,

despatchdate;

DROP Table source;

Re: remaining by rows

Mon, 05 May 2014 15:20:43 GMT

Good afternoon Massimo,

thanks a lot for you reply!

Are you Italian?

Can I write you in Italian directly so I can explain better my issue?

Regards

Mauro

Da: Massimo Grossi

Inviato: lunedì 5 maggio 2014 14:24

A: Venzo, Mauro

Oggetto: Re: - remaining by rows

Qlik Community<http://community.qlik.com/>

remaining by rows

reply from Massimo Grossi<http://community.qlik.com/people/maxgro?et=watches.email.thread> in New to QlikView - View the full discussion<http://community.qlik.com/message/522054?et=watches.email.thread#522054>

Re: remaining by rows

Mon, 05 May 2014 15:54:45 GMT

article despatch-date good-entry stock-lev sales

xxxx1 03/05/14 5000 1000

xxxx1 10/05/14 4000 500

xxxx1 11/05/14 3500 100

xxxx1 13/05/14 3400 500

xxxx1 15/05/14 2900

Yes, I would like to calcolate the stock level by the formula (if it's possible) and not "SCRIPT".

thanks for your reply

Mauro

Re: Re: remaining by rows

tresB — Tue, 06 May 2014 04:53:29 GMT

See attached qvw.

Re: Re: remaining by rows

Wed, 07 May 2014 06:51:26 GMT

thanks a lot!