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

    Integrate data from other Dim in a Straight Table - Accounting

    Aviad Bein

      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:

      Illustration.PNG


      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:

       

      if(BalanceSheetHeading='Net Loss', sum({<FinancialStatement={'P&L'},ProfitLossHeading={'Net Loss'}>}BALANCE), sum(BALANCE))

       

      but unfortunately without success so far. any ideas?

       

      Thanks in advance,

      Aviad