Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to generate financial statements through Qlik Sense desktop and now that I'm doing the cash flow I have ran into a bit of problem.
I'm wondering if it's possible to pull data from one sheet to another, like I do in excel, in order to create the demonstrate the changes in assets, liabilities, etc. Or links charts, so that the data from one could be used in another.
I welcome any ideas.
Thank you!
Hi Carahyba,
Thanks for replying!
In the worksheet where I have the Balance Sheet, I have created the measures (formulas) for accounts payables, receivables, PPE, Depreciation, etc., that take the raw data from the transactions in the excel uploaded to the app.
Therefore, what I want is to pull the result from the formulas on the BS worksheet and put in the cash flow (on another sheet) so that they can be subtracted or aggregated, so that I can see the changes by month and year.
Its like when in excel you subtract one cell from another, and it can be done throughout documents, sheets, etc.
Hello!
I have also come across the same kind of issue.
However, how do you take the formulas into the LOAD script?
Thank You!