0 Replies Latest reply: Nov 3, 2016 10:21 AM by Nima Vahedi RSS

    percentage of total

    Nima Vahedi

      Hi

      In my project, I have several calculation types loaded as "Calc" in an inline table. I've written a different expression for
      each calculation type except some that are similar, combined into an expression using "Pick()" function.

       

      For example, take these as my calculation types:

      Rank;

      Group;

      Ratio1;

      Ratio2;

      Ratio3;          

      The last three items have the same expression that is the amount in the mentioned ratio. The number of these calculation types may increase in future. So I've written this expression for my table:

       

      Pick(NumMin(3,Calc_ID)
      ,
      First Experssion

      ,Second Experssion

      ,Sum({<Year={$(=Max(Year))}>}
      if(RatioID=Calc_Ratio,Value))
      )

      Then I tried to write an expression for percentage of total of each calculation Item and the result was this table:

      92.png
      The problem is that I can't seem to get to 100% on total rows, it seems it calculates the percentage for the whole three columns.

      Any Ideas of how to implement this??

      Thanks in advance.

      PS. I've attached a Qlikview Sample: