6 Replies Latest reply: Jul 25, 2017 9:25 AM by Mouna Chandra Konidhina RSS

    Ratio in Account Balance

    Isabela Cinca

      Hello,

       

      i am new using QlikSense and I have a problem in calculating a ratio.

      I need to calculate the ratio by dividing each voice of Account Balance By revenue that in this case is highlighted in yellow.

      So i need to do : -16-487.675,09/ 30.833.658,42 or -2.125.011,63/30.833.658,42 end so on.

      Now my measure is like this but i can't fix the voce of revenue as denominator:

      num( (sum (if ( [Anno Fiscale] = $(vAnnoFiscale),[Valore]))

      /

      (sum (if ([Voce Conto Economico]= 'A' and [Anno Fiscale] = $(vAnnoFiscale),[Valore])))),

      '%#.##0,0')

       

      Where [Voce Conto Economico] is the voce of the account Balance and 'A' is the Revenue.


      InkedCattura7_LI.jpg

       

      Thank you,

      Isabela