topic Re: Link Actual Data with Transaction History in QlikView

Link Actual Data with Transaction History

Tue, 18 Jun 2013 10:27:40 GMT

Hello,

I am working on some project and i want to combine the following data:

Current Stock

- Amount of articles in stock for each article. Only what the stock looks like right now.

Transaction History

- For each article it gives the transaction history. So for example:

Article	TransactionDate	Transaction
TestArticle1	02-02-2013	-20
TestArticle2	04-02-2013	+5

I want to make the transaction history visible, how can i do this?

Tue, 18 Jun 2013 11:57:17 GMT

I am looking for an example how to do something like this.

Right now I'm going to try the previous(); function

Tue, 18 Jun 2013 12:37:56 GMT

U need to create a Calender Master Based on Transaction Date.

Set Variable vMaxYear= Max(Year)

Exp : For Currentyear = Sum({<Year={$(vMaxYear)}>}Transaction)

For Lastyear = Sum({<Year={$(=Max(Year(Year))-1)>}Transaction)

It will show Year wise Transaction,If u want to put month,then inside exp include month

Regards,

Bika