topic individual sum percentage in QlikView

individual sum percentage

Fri, 16 Mar 2012 08:10:58 GMT

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

individual sum percentage

jvitantonio — Fri, 16 Mar 2012 08:25:07 GMT

Can you post your app?

Re: individual sum percentage

Mon, 19 Mar 2012 06:22:40 GMT

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

jvitantonio — Mon, 19 Mar 2012 08:24:20 GMT

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

Tue, 20 Mar 2012 08:59:36 GMT

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

jvitantonio — Tue, 20 Mar 2012 10:16:03 GMT

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

individual sum percentage

Tue, 20 Mar 2012 10:34:22 GMT

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

Re: individual sum percentage

Wed, 21 Mar 2012 10:52:11 GMT

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

individual sum percentage

jvitantonio — Wed, 21 Mar 2012 10:56:21 GMT

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

Re: individual sum percentage

Wed, 21 Mar 2012 11:08:53 GMT

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

individual sum percentage

jvitantonio — Wed, 21 Mar 2012 11:44:58 GMT

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

Wed, 21 Mar 2012 12:14:55 GMT

thank you qlikuser14, may i have your YM?

so i can ask you directly next time

individual sum percentage

jvitantonio — Wed, 21 Mar 2012 13:01:31 GMT