Pulling Data from Other Worksheets

[renatarissodm]

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!

[JordyWegman]

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

[raja_indianprak]

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