Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
maxrs123
New Contributor II

Taking the Gross Value of t=-1, adding the most Current addition (t=0)and Substracting the Gross Value of t=0

Hello Guys,

Im hoping that you experts can help me out here.

So concerning my case I have following Problem: Im Conducting Research on a Pension System and would like to figure out a spezific number therefore.

The Pension account works as following, There is an account where Money has to be stored for costs that will come in the future, however the is no exact date when These costs will occure. Therefore, Money leaves the account and also fills the account. I would like to figure out how much Money ist flowing oút. The Calculation for this Problem manually would look like the following: ("Full Value of the account at time - 1 year" + "the Money that has been added to the account at time= 0") - "The Value of the account at time=0".

I would like to do it in a bar Chart, therefore I belive that a simple formula would be the easiest way to solve my Problem.

Im very thank full for every good tip and all help that you guys offer,

Best regards,

Max

1 Reply
MVP & Luminary
MVP & Luminary

Re: Taking the Gross Value of t=-1, adding the most Current addition (t=0)and Substracting the Gross Value of t=0