topic Re: Problem facing when using Above(), Multi Dimension in App Development https://community.qlik.com/t5/App-Development/Problem-facing-when-using-Above-Multi-Dimension/m-p/1229467#M23993 <HTML><HEAD></HEAD><BODY><P>Thanks a lot. I gt it right.</P></BODY></HTML> Thu, 26 Jan 2017 10:06:13 GMT 2017-01-26T10:06:13Z Problem facing when using Above(), Multi Dimension https://community.qlik.com/t5/App-Development/Problem-facing-when-using-Above-Multi-Dimension/m-p/1229464#M23990 <HTML><HEAD></HEAD><BODY><P><IMG alt="2017-01-20 18_40_34-Qlik Sense Desktop.jpg" class="jive-image image-1" src="/legacyfs/online/150221_2017-01-20 18_40_34-Qlik Sense Desktop.jpg" style="height: 280px; width: 620px;" /></P><P>As you can see from the picture, the line for "Large Corp" disappeared because of the usage of <STRONG>Above function.</STRONG></P><P>I want to specific the calculation using above function refer to dimension "Quarter" and then split by Dimension "Size".</P><P>Is there any solution for this?</P><P>This is the formula of measure : <SPAN style="font-size: 13.3333px;">(sum(Outstanding)-Above(Sum(Outstanding)))/Above(Sum(Outstanding))</SPAN></P></BODY></HTML> Wed, 25 Jan 2017 03:58:42 GMT https://community.qlik.com/t5/App-Development/Problem-facing-when-using-Above-Multi-Dimension/m-p/1229464#M23990 2017-01-25T03:58:42Z Re: Problem facing when using Above(), Multi Dimension https://community.qlik.com/t5/App-Development/Problem-facing-when-using-Above-Multi-Dimension/m-p/1229465#M23991 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG><SPAN style="color: #ff0000;">Aggr(</SPAN>(Sum(Outstanding) - Above(Sum(Outstanding)))/<SPAN style="font-size: 13.3333px;">Above(Sum(Outstanding))</SPAN><SPAN style="color: #ff0000;">, Size</SPAN><SPAN style="color: #ff0000;">, Quarter)</SPAN></STRONG></P></BODY></HTML> Wed, 25 Jan 2017 10:05:36 GMT https://community.qlik.com/t5/App-Development/Problem-facing-when-using-Above-Multi-Dimension/m-p/1229465#M23991 sunny_talwar 2017-01-25T10:05:36Z Re: Problem facing when using Above(), Multi Dimension https://community.qlik.com/t5/App-Development/Problem-facing-when-using-Above-Multi-Dimension/m-p/1229466#M23992 <HTML><HEAD></HEAD><BODY><P>Or this:</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">Aggr(</SPAN>(Sum(Outstanding) - Above(Sum(Outstanding)))/<SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">Above(Sum(Outstanding))</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">, Size</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">, (Quarter, (TEXT, ASCENDING)))</SPAN></STRONG></P></BODY></HTML> Wed, 25 Jan 2017 10:07:06 GMT https://community.qlik.com/t5/App-Development/Problem-facing-when-using-Above-Multi-Dimension/m-p/1229466#M23992 sunny_talwar 2017-01-25T10:07:06Z Re: Problem facing when using Above(), Multi Dimension https://community.qlik.com/t5/App-Development/Problem-facing-when-using-Above-Multi-Dimension/m-p/1229467#M23993 <HTML><HEAD></HEAD><BODY><P>Thanks a lot. I gt it right.</P></BODY></HTML> Thu, 26 Jan 2017 10:06:13 GMT https://community.qlik.com/t5/App-Development/Problem-facing-when-using-Above-Multi-Dimension/m-p/1229467#M23993 2017-01-26T10:06:13Z