individual sum percentage

[#1]

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

[jvitantonio · Accepted solution]

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.

[#3]

thank you qlikuser14, may i have your YM?

so i can ask you directly next time

[jvitantonio]