Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

quintansjoel
New Contributor

(QlikSense) Cashflow with values of different years or months

Hey

I need to make a Cashflow using a pivot table in Qlik Sense which let you see the values of all the different steps of the formula for the rows, and the period (year or months) on the columns.

I succeeded in making it for the years, but it doesn't work if i try this with the months.

To calculate the cashflow, you need values from your P&L and Balance sheet. You also need the values of the previous period in order to calculate it.

Does someone know how i can approach this the best way so that i can see the cashflow of every year and every month?

In the picture below you see how the cashflow of the years look like. I need the same with the months or, if possible, a period you select.

CashFlow.PNG

Tags (2)
1 Reply
ogster1974
Honored Contributor II

Re: (QlikSense) Cashflow with values of different years or months

Here is a simple cashflow app using a straight table but the principle is the same.

Community Browser