topic Pulling Data from Other Worksheets in App Development

Pulling Data from Other Worksheets

renatarissodm — Sat, 16 Nov 2024 20:29:11 GMT

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.

I welcome any ideas.

Thank you!

Re: Pulling Data from Other Worksheets

JordyWegman — Tue, 16 Jul 2019 09:35:34 GMT

Hi,

Why from other sheets? Because the data is in your data model and you can use all the data on every worksheet. It could be that you need to prepare this data.

Jordy
Climber

Re: Pulling Data from Other Worksheets

raja_indianprak — Thu, 18 Jul 2019 07:52:36 GMT

Hello,

You could do all financial statements from Simple QLIKSENSE pivot table object itself.

Actually you could drill down and able to see the changes. Example, from P&L statement

If Revenue (Group) could be splitted as Sale of products, Sale of services (Sub Group) then you could drill down these sub groups from Main group.

Revert, if you've any doubts.

Regards,

Raja Indianprakaash