topic Re: Set Analysis + AGGR in App Development https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275477#M26388 <HTML><HEAD></HEAD><BODY><P>is that dimension name or dimension value?</P></BODY></HTML> Thu, 24 Nov 2016 12:56:32 GMT MK_QSL 2016-11-24T12:56:32Z Set Analysis + AGGR https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275471#M26382 <HTML><HEAD></HEAD><BODY><P>Hallo zusammen,</P><P></P><P>ich würde gerne in dieser Formel die Dimension mitgeben für die gerechnet werden soll. Leider bekomme ich die Syntax nicht hin. Könnt ihr mir helfen?</P><P></P><P>=Sum({$&lt;Artikelpostenart = {"Istmeldung"}&gt;} Artikelpostenmenge)</P><P></P><P>Die Dimension wäre Beispielsweise "[FA-Nr.]".</P><P></P><P>Vielen Dank im vorraus.</P><P>Mike</P></BODY></HTML> Fri, 18 Nov 2016 14:01:47 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275471#M26382 qlikview2015 2016-11-18T14:01:47Z Re: Set Analysis + AGGR https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275472#M26383 <HTML><HEAD></HEAD><BODY><P>Hat keiner eine Idee?</P></BODY></HTML> Thu, 24 Nov 2016 09:28:25 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275472#M26383 qlikview2015 2016-11-24T09:28:25Z Re: Set Analysis + AGGR https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275473#M26384 <HTML><HEAD></HEAD><BODY><P>What exactly you want to do?</P></BODY></HTML> Thu, 24 Nov 2016 09:31:43 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275473#M26384 MK_QSL 2016-11-24T09:31:43Z Re: Set Analysis + AGGR https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275474#M26385 <HTML><HEAD></HEAD><BODY><P>There are many other Dimensions in the Diagramm, but I want only to sum the [Artikelpostenmenge] with the Dimension [FA-Nr.], if Artikelpostenart = Istmeldung.</P></BODY></HTML> Thu, 24 Nov 2016 10:57:30 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275474#M26385 qlikview2015 2016-11-24T10:57:30Z Re: Set Analysis + AGGR https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275475#M26386 <HTML><HEAD></HEAD><BODY><P>What is meaning by <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">with the Dimension [FA-Nr.]?</SPAN></P></BODY></HTML> Thu, 24 Nov 2016 12:42:05 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275475#M26386 MK_QSL 2016-11-24T12:42:05Z Re: Set Analysis + AGGR https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275476#M26387 <HTML><HEAD></HEAD><BODY><P>[FA-Nr.] is the Dimension for the sum.</P></BODY></HTML> Thu, 24 Nov 2016 12:53:42 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275476#M26387 qlikview2015 2016-11-24T12:53:42Z Re: Set Analysis + AGGR https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275477#M26388 <HTML><HEAD></HEAD><BODY><P>is that dimension name or dimension value?</P></BODY></HTML> Thu, 24 Nov 2016 12:56:32 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275477#M26388 MK_QSL 2016-11-24T12:56:32Z Re: Set Analysis + AGGR https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275478#M26389 <HTML><HEAD></HEAD><BODY><P>Not sure, but may be this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=Sum(<SPAN style="color: #ff0000;">TOTAL &lt;<SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">[FA-Nr.]</SPAN>&gt;</SPAN> {$&lt;Artikelpostenart = {"Istmeldung"}&gt;} Artikelpostenmenge)</STRONG></SPAN></P></BODY></HTML> Thu, 24 Nov 2016 13:02:26 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275478#M26389 sunny_talwar 2016-11-24T13:02:26Z Re: Set Analysis + AGGR https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275479#M26390 <HTML><HEAD></HEAD><BODY><P>The name</P></BODY></HTML> Thu, 24 Nov 2016 15:30:43 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275479#M26390 qlikview2015 2016-11-24T15:30:43Z Re: Set Analysis + AGGR https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275480#M26391 <HTML><HEAD></HEAD><BODY><P>I will try it in the next few days and give an answer.</P></BODY></HTML> Thu, 24 Nov 2016 15:31:21 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-AGGR/m-p/1275480#M26391 qlikview2015 2016-11-24T15:31:21Z