topic Re: Stock position on a given date in QlikView

Stock position on a given date

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

I have a table with the movement of stock to the position on .

I managed to get the most earliest date that the informed variable, but can not get the amount in stock on the date .

Portugues:

Eu tenho uma tabela com o movimento do estoque para a posição ligado.
Eu consegui a data mais mais antiga que a variável informada , mas não pode obter a quantidade em estoque na data .

Re: Stock position on a given date

sunny_talwar — Mon, 11 Jul 2016 18:29:36 GMT

This?

Re: Stock position on a given date

Anonymous — Tue, 12 Jul 2016 10:29:30 GMT

Yes, Thank you...

Re: Stock position on a given date

Anonymous — Tue, 12 Jul 2016 16:29:23 GMT

Making new tests to the data, I noticed that some items are not correct. The following example.

Re: Stock position on a given date

sunny_talwar — Tue, 12 Jul 2016 16:39:17 GMT

Can you post this application?

Re: Stock position on a given date

Anonymous — Tue, 12 Jul 2016 17:17:33 GMT

attached .qvw

Re: Stock position on a given date

sunny_talwar — Tue, 12 Jul 2016 17:39:13 GMT

I guess this is not a good example because in this case my earlier provided expression seems to work well. Can you provide another example where my expression is causing an issue for you

Re: Stock position on a given date

Anonymous — Tue, 12 Jul 2016 17:55:40 GMT

If you use the function Collapse All without filter , will not bring values.

Re: Stock position on a given date

Anonymous — Wed, 13 Jul 2016 12:20:20 GMT

Someone with some new suggestions?

Alguém com alguma nova sugestão?

Re: Stock position on a given date

sunny_talwar — Wed, 13 Jul 2016 12:37:05 GMT

What is the expected output based on collapsing and non-collapsing of the chart? Provide this based on two set of different selections because I am still not able to understand the issue

Re: Stock position on a given date

Anonymous — Wed, 13 Jul 2016 12:47:39 GMT

Goal is to know the balance of stock on a particular date , informed the variable.

I look at these information by opening deposit or by product , product derivation , through the collapse function or not collapse .
I have several charts / tables for this information

Re: Stock position on a given date

Anonymous — Wed, 13 Jul 2016 18:12:01 GMT

The expected result is to know the stock of products on a certain date ( variable ) . Having collapse or expansion of deposit , Product , Product Derivation . I need information for Storage, Product , Derivation products, can use the function to collapse or not. Always grouping and adding the data or may be in different blocks of data.

Re: Stock position on a given date

sunny_talwar — Sat, 16 Jul 2016 03:43:52 GMT

How does this look?

Expression used:

=FirstSortedValue({<DataMovimentoPosicao = {"<=$(vDataBase)"}>} Aggr(Sum({<DataMovimentoPosicao = {"<=$(vDataBase)"}>}QtdeEstoquePosicao), DataMovimentoPosicao, CodigoDepositoPosicao),

-Aggr(DataMovimentoPosicao, DataMovimentoPosicao, CodigoDepositoPosicao))