12 Replies Latest reply: Mar 21, 2012 9:01 AM by j i RSS

    individual sum percentage

    Winprins Tambunan

      hi all,

      i'm new in qlikview set analyst function, i have a case where i need to show the range percentage "each month" in one chart

      dimensions are RANGE and MONTH,

      the expression is : (SUM(OSPHNPLNew) / SUM(total OSPHNPLNew))

      then the result seems the percentage of OSPH by total (osph/total osph)  (max y value = 15 %)

      i need a set analyst to show the real value (max y value = 100 %) for each month .

      can somebody help me ? thank you

       

      New Picture (11).bmp