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.
Hi. What kind of data do you want to pull from one sheet to another? Because QlikSense data is always available in any sheet, and by default all filter selections in one sheet is reflected in the whole app. Regards.
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.