5 Replies Latest reply: May 25, 2017 6:40 AM by Sunny Talwar

# Integrate data from other Dim in a Straight Table - Accounting

I all,

I have developed a Profit & Loss and Balance Sheet following this two posts: https://community.qlik.com/docs/DOC-3324 and https://community.qlik.com/blogs/qlikviewdesignblog/2012/08/10/how-intervalmatch-solved-my-profit-and-loss-dilemma

and it's all work perfect except one issue.

I'm having a problem with integrating the Income Statement (Profit & Loss) and Balance Sheet.

an illustration of my need:

basically, I need to display a value from a Dim other than the one that my table is bound to.

If I'll be more specifically, as you can see, the value "Net Loss" (Profit & Loss Dim) is calculated on the P&L data and I want to integrate this value in a straight table of Balance Sheet Dim.

I have tried with set analysis, something like this:

but unfortunately without success so far. any ideas?

• ###### Re: Integrate data from other Dim in a Straight Table - Accounting

Try this

If(BalanceSheetHeading = 'Net Loss', Sum(TOTAL {<FinancialStatement={'P&L'}, ProfitLossHeading = {'Net Loss'}>} BALANCE), Sum(BALANCE))

• ###### Re: Integrate data from other Dim in a Straight Table - Accounting

It works! BUT, when i select date, let's say year=2017, it become 0. Why so?

• ###### Re: Integrate data from other Dim in a Straight Table - Accounting

Try this

If(Only({1} BalanceSheetHeading) = 'Net Loss', Sum(TOTAL {<FinancialStatement={'P&L'}, ProfitLossHeading = {'Net Loss'}, Year>} BALANCE), Sum(BALANCE))

• ###### Re: Integrate data from other Dim in a Straight Table - Accounting

Great!

I just made a little change: