topic Re: How to use this expression in calculate dimension in QlikView https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486861#M181868 <HTML><HEAD></HEAD><BODY><P>I really have no idea what you're trying to do. You can try removing the outer sum from your expression or adding an aggr around it that uses those dimensions again. The latter option doesn't make sense to me. Maybe you should simply try both options and see if one does what you want.</P></BODY></HTML> Thu, 09 Jan 2014 08:01:44 GMT Gysbert_Wassenaar 2014-01-09T08:01:44Z How to use this expression in calculate dimension https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486855#M181862 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>I have following expression &amp; I want to use this in calculated dimension how do I use in calculated dimension</P><P></P><P>=(SUM({&lt;FinancialYear=,Quarter=,MonthName=&gt;} AGGR(if( (Date(vDateForAgeing)-if(isnull(Date([DUE_DATE])),1,Date([DUE_DATE])) &lt;=30),SUM({$&lt;FinancialYear=,Quarter=,MonthName=,[Posting Date] ={"&lt;=$(=MonthEnd(Max([Posting Date])))"}&gt;}[Net Outstanding])),DOC_NO,Customer,Location))</P><P>/100000) </P><P></P><P>Vikas</P></BODY></HTML> Thu, 09 Jan 2014 07:42:54 GMT https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486855#M181862 vikasmahajan 2014-01-09T07:42:54Z Re: How to use this expression in calculate dimension https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486856#M181863 <HTML><HEAD></HEAD><BODY><P>You need to put an aggr around it so it calculates sum values over one or more dimensions.</P></BODY></HTML> Thu, 09 Jan 2014 07:46:21 GMT https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486856#M181863 Gysbert_Wassenaar 2014-01-09T07:46:21Z Re: How to use this expression in calculate dimension https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486857#M181864 <HTML><HEAD></HEAD><BODY><P>Do you really want a numeric value to be used as a dimension?</P></BODY></HTML> Thu, 09 Jan 2014 07:46:23 GMT https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486857#M181864 tresB 2014-01-09T07:46:23Z Re: How to use this expression in calculate dimension https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486858#M181865 <HTML><HEAD></HEAD><BODY><P>Can you modify and send me how ?</P><P></P><P>Vikas</P></BODY></HTML> Thu, 09 Jan 2014 07:51:09 GMT https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486858#M181865 vikasmahajan 2014-01-09T07:51:09Z Re: How to use this expression in calculate dimension https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486859#M181866 <HTML><HEAD></HEAD><BODY><P>No, because I don't know which dimensions you want to aggregate the sums over. You already have an aggr function in that expression so you should know how aggr works.</P></BODY></HTML> Thu, 09 Jan 2014 07:53:44 GMT https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486859#M181866 Gysbert_Wassenaar 2014-01-09T07:53:44Z Re: How to use this expression in calculate dimension https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486860#M181867 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">DOC_NO,Customer,Location&nbsp; this are my dims used for aggr</SPAN></P></BODY></HTML> Thu, 09 Jan 2014 07:57:06 GMT https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486860#M181867 vikasmahajan 2014-01-09T07:57:06Z Re: How to use this expression in calculate dimension https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486861#M181868 <HTML><HEAD></HEAD><BODY><P>I really have no idea what you're trying to do. You can try removing the outer sum from your expression or adding an aggr around it that uses those dimensions again. The latter option doesn't make sense to me. Maybe you should simply try both options and see if one does what you want.</P></BODY></HTML> Thu, 09 Jan 2014 08:01:44 GMT https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486861#M181868 Gysbert_Wassenaar 2014-01-09T08:01:44Z Re: How to use this expression in calculate dimension https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486862#M181869 <HTML><HEAD></HEAD><BODY><P>I want to display&nbsp; 0-30 in bucket&nbsp; and rest in expression</P></BODY></HTML> Thu, 09 Jan 2014 08:52:08 GMT https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486862#M181869 vikasmahajan 2014-01-09T08:52:08Z Re: How to use this expression in calculate dimension https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486863#M181870 <HTML><HEAD></HEAD><BODY><P>Could you post your sample app with sample data?</P></BODY></HTML> Thu, 09 Jan 2014 09:21:32 GMT https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486863#M181870 tresB 2014-01-09T09:21:32Z Re: How to use this expression in calculate dimension https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486864#M181871 <HTML><HEAD></HEAD><BODY><P>application can not share thanks.</P><P></P><P>Vikas</P></BODY></HTML> Thu, 09 Jan 2014 09:30:17 GMT https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486864#M181871 vikasmahajan 2014-01-09T09:30:17Z Re: How to use this expression in calculate dimension https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486865#M181872 <HTML><HEAD></HEAD><BODY><P>Scramble the data and share it</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4032">http://community.qlik.com/docs/DOC-4032</A></P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-1290">http://community.qlik.com/docs/DOC-1290</A></P></BODY></HTML> Thu, 09 Jan 2014 10:15:21 GMT https://community.qlik.com/t5/QlikView/How-to-use-this-expression-in-calculate-dimension/m-p/486865#M181872 2014-01-09T10:15:21Z