topic calculated dimension or expression in QlikView https://community.qlik.com/t5/QlikView/calculated-dimension-or-expression/m-p/715127#M1076410 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want to create a calculated dimension which shows the Minimum date and another calculated dimension which shows maximum date.</P><P></P><P>In the data for each person a Fromdate and Todate is generated, whenever he booked the contract and ended that contract.</P><P></P><P>Eg- ID 1011 has many from and todates, and because of that Amount is repeated.</P><P>Eg- Similarly in ID , 1146 the amount is repeated&nbsp; everytime there is different from and todate</P><P></P><P>I am not interested in all the line items, but only the begining FromDate and final ToDate of the whole contract. So that i can only see one total Amount.</P><P></P><P>To achieve this, i think i have to create a calculated dimension.</P><P></P><P>Could anyone help me with that please..</P></BODY></HTML> Mon, 21 Jul 2014 09:13:52 GMT surajap123 2014-07-21T09:13:52Z calculated dimension or expression https://community.qlik.com/t5/QlikView/calculated-dimension-or-expression/m-p/715127#M1076410 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want to create a calculated dimension which shows the Minimum date and another calculated dimension which shows maximum date.</P><P></P><P>In the data for each person a Fromdate and Todate is generated, whenever he booked the contract and ended that contract.</P><P></P><P>Eg- ID 1011 has many from and todates, and because of that Amount is repeated.</P><P>Eg- Similarly in ID , 1146 the amount is repeated&nbsp; everytime there is different from and todate</P><P></P><P>I am not interested in all the line items, but only the begining FromDate and final ToDate of the whole contract. So that i can only see one total Amount.</P><P></P><P>To achieve this, i think i have to create a calculated dimension.</P><P></P><P>Could anyone help me with that please..</P></BODY></HTML> Mon, 21 Jul 2014 09:13:52 GMT https://community.qlik.com/t5/QlikView/calculated-dimension-or-expression/m-p/715127#M1076410 surajap123 2014-07-21T09:13:52Z Re: calculated dimension or expression https://community.qlik.com/t5/QlikView/calculated-dimension-or-expression/m-p/715128#M1076411 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P></P><P>Use Updated Version..</P></BODY></HTML> Mon, 21 Jul 2014 09:17:15 GMT https://community.qlik.com/t5/QlikView/calculated-dimension-or-expression/m-p/715128#M1076411 MK_QSL 2014-07-21T09:17:15Z Re: calculated dimension or expression https://community.qlik.com/t5/QlikView/calculated-dimension-or-expression/m-p/715129#M1076412 <HTML><HEAD></HEAD><BODY><P>Use the AGGR statement to do the calculation</P><P></P><P>AGGR(MIN(FromDate),[ID]))</P></BODY></HTML> Mon, 21 Jul 2014 12:20:45 GMT https://community.qlik.com/t5/QlikView/calculated-dimension-or-expression/m-p/715129#M1076412 DavidFoster1 2014-07-21T12:20:45Z Re: calculated dimension or expression https://community.qlik.com/t5/QlikView/calculated-dimension-or-expression/m-p/715130#M1076413 <HTML><HEAD></HEAD><BODY><P>Thanks guys !!</P></BODY></HTML> Mon, 21 Jul 2014 14:13:38 GMT https://community.qlik.com/t5/QlikView/calculated-dimension-or-expression/m-p/715130#M1076413 surajap123 2014-07-21T14:13:38Z