Solved: Re: individual sum percentage - Qlik Community

Report Inappropriate Content · ‎2012-03-16

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 · ‎2012-03-21

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.

View solution in original post

jvitantonio · ‎2012-03-16

Can you post your app?

Report Inappropriate Content · ‎2012-03-19

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

jvitantonio · ‎2012-03-19

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??

Report Inappropriate Content · ‎2012-03-20

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

jvitantonio · ‎2012-03-20

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

Report Inappropriate Content · ‎2012-03-20

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.....

Report Inappropriate Content · ‎2012-03-21

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

i already upload the file, i need your approval to view the file,

need help soon,

thank you

jvitantonio · ‎2012-03-21

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

Report Inappropriate Content · ‎2012-03-21

http://community.qlik.com/docs/DOC-2884 here is the link, can you download the file?