12 Replies Latest reply: Mar 21, 2012 9:01 AM by Juan Vitantonio

individual sum percentage

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

• Re: individual sum percentage

thanks qlikuser14,

i already put the screen shot, as shown on the chart, the max percentage is 15% ,i need a set analyst  function to get each month percentage (100 %)

my last expression is :

(SUM(OSPHNPLNew) / SUM(total OSPHNPLNew))

can you help me adding some set analyst ?

thank you

• individual sum percentage

I'd love to help but I really don't understand what you need. You are telling me that the max % is 35 but you want to get 100%? What do you mean??

• Re: individual sum percentage

thanks qlikuser14

sorry for mistyping 35 % in my last reply,

the main question is how to get this result (total percentage of September is 100 %)

when all months selected in this chart?

my last expression is :

(SUM(OSPHNPLNew) / SUM(total OSPHNPLNew))

can you help me adding some set analyst to show the percentage (100%) as i selected one month(picture 1), in a chart with all month selected (picture 2)?

thank you clikuser14

• individual sum percentage

You should use the Aggr() function. Something like Aggr(Sum(Value),Month)

If you post your application with sample data I can work on it

• Re: individual sum percentage

thanks qlikuser 14, the aggr function still won't show good result,

need help soon,

thank you

• individual sum percentage

What do you mean you needmy approval? I see no file here...

• individual sum percentage

Ok navarone,done.

Go to the expressions and replace what you have in "percentage" with this formula:

sum(OSPHNPLBaru)/aggr(nodistinct sum(OSPHNPLBaru),month)

I hope this helps.

• Re: individual sum percentage

thank you qlikuser14, may i have your YM?

so i can ask you directly next time

• individual sum percentage

I think u have marked it relative (under expression tab in chart properties)....so individual month will always show 100%....un-check it to have actual results.....