Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Can you post your app?
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
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??
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
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
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.....
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
What do you mean you needmy approval? I see no file here...
http://community.qlik.com/docs/DOC-2884 here is the link, can you download the file?