topic Re: Expression on TopX Dimension in QlikView https://community.qlik.com/t5/QlikView/Expression-on-TopX-Dimension/m-p/424762#M158218 <HTML><HEAD></HEAD><BODY><P>if A is the dmension of your chart, and your X is 3, is :</P><P></P><P style="font-size: 9px; font-family: 'Courier New'; color: #941100;"><SPAN style="font-size: 10pt;"><SPAN style="color: #0433ff;">sum</SPAN><SPAN style="color: #000000;">(&nbsp; </SPAN><SPAN style="color: #0433ff;">if</SPAN><SPAN style="color: #000000;"> ( </SPAN>anothermesure<SPAN style="color: #000000;"> &gt;=&nbsp; </SPAN><SPAN style="color: #0433ff;">max</SPAN><SPAN style="color: #000000;">( </SPAN><SPAN style="color: #0433ff;">total</SPAN><SPAN style="color: #000000;">&nbsp; </SPAN>anothermesure<SPAN style="color: #000000;"> , 3) , </SPAN>mesure<SPAN style="color: #000000;"> )) </SPAN></SPAN></P><P></P><P><SPAN style="color: #000000;">OK ?</SPAN></P><P></P><P><SPAN style="color: #000000;">(i'm not sure what is your dimension B in this context)<BR /></SPAN></P></BODY></HTML> Thu, 30 May 2013 16:14:15 GMT 2013-05-30T16:14:15Z Expression on TopX Dimension https://community.qlik.com/t5/QlikView/Expression-on-TopX-Dimension/m-p/424761#M158217 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm showing a simple SUM(Measure) by a dimension A.</P><P>Now i would also like to show the SUM(Measure) for only for the TopX SUM(anotherMeasure) by dimension B ignoring dimension A</P><P></P><P>any suggestion</P></BODY></HTML> Thu, 30 May 2013 13:36:11 GMT https://community.qlik.com/t5/QlikView/Expression-on-TopX-Dimension/m-p/424761#M158217 2013-05-30T13:36:11Z Re: Expression on TopX Dimension https://community.qlik.com/t5/QlikView/Expression-on-TopX-Dimension/m-p/424762#M158218 <HTML><HEAD></HEAD><BODY><P>if A is the dmension of your chart, and your X is 3, is :</P><P></P><P style="font-size: 9px; font-family: 'Courier New'; color: #941100;"><SPAN style="font-size: 10pt;"><SPAN style="color: #0433ff;">sum</SPAN><SPAN style="color: #000000;">(&nbsp; </SPAN><SPAN style="color: #0433ff;">if</SPAN><SPAN style="color: #000000;"> ( </SPAN>anothermesure<SPAN style="color: #000000;"> &gt;=&nbsp; </SPAN><SPAN style="color: #0433ff;">max</SPAN><SPAN style="color: #000000;">( </SPAN><SPAN style="color: #0433ff;">total</SPAN><SPAN style="color: #000000;">&nbsp; </SPAN>anothermesure<SPAN style="color: #000000;"> , 3) , </SPAN>mesure<SPAN style="color: #000000;"> )) </SPAN></SPAN></P><P></P><P><SPAN style="color: #000000;">OK ?</SPAN></P><P></P><P><SPAN style="color: #000000;">(i'm not sure what is your dimension B in this context)<BR /></SPAN></P></BODY></HTML> Thu, 30 May 2013 16:14:15 GMT https://community.qlik.com/t5/QlikView/Expression-on-TopX-Dimension/m-p/424762#M158218 2013-05-30T16:14:15Z Re: Expression on TopX Dimension https://community.qlik.com/t5/QlikView/Expression-on-TopX-Dimension/m-p/424763#M158219 <HTML><HEAD></HEAD><BODY><P>variable vTopX: 5</P><P>dimension: DimA</P><P>expression: sum({&lt;DimB={"=rank(sum({&lt;DimA=&gt;}MeasureB))&lt;=$(vTopX)"}&gt;}MeasureA)</P></BODY></HTML> Thu, 30 May 2013 17:28:13 GMT https://community.qlik.com/t5/QlikView/Expression-on-TopX-Dimension/m-p/424763#M158219 Gysbert_Wassenaar 2013-05-30T17:28:13Z Re: Expression on TopX Dimension https://community.qlik.com/t5/QlikView/Expression-on-TopX-Dimension/m-p/424764#M158220 <HTML><HEAD></HEAD><BODY><P>I was trying to do sth like that but was unable to find how to.</P><P></P><P>Very nice formula !</P></BODY></HTML> Thu, 30 May 2013 17:42:17 GMT https://community.qlik.com/t5/QlikView/Expression-on-TopX-Dimension/m-p/424764#M158220 2013-05-30T17:42:17Z