Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Link Actual Data with Transaction History

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:

ArticleTransactionDateTransaction
TestArticle102-02-2013-20
TestArticle204-02-2013+5

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

2 Replies
Not applicable

Re: Link Actual Data with Transaction History

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

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

Not applicable

Re: Link Actual Data with Transaction History

Hi

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

Community Browser