topic Calculated dimension + AGGR in QlikView https://community.qlik.com/t5/QlikView/Calculated-dimension-AGGR/m-p/475342#M177514 <HTML><HEAD></HEAD><BODY><P>Is it possible to use an expression as calculated dimension when expression itself was calculated using AGGR as dimension. I want to use Decile as calculated dimension for further analysis. Expression behind the decile is&nbsp; ( I have attached the application for reference)</P><P></P><P>10-(div(((RangeSum(above(TOTAL sum(OrderCount),0,RowNo(TOTAL))))/sum(TOTAL OrderCount))*9.99999999999,1))</P><P></P><P>Can you help me create 'Decile' from this application as calculated dimension? Thanks. </P><P></P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/49413_pastedImage_1.png" style="width: 620px; height: 269px;" /></P></BODY></HTML> Thu, 21 Nov 2013 21:31:39 GMT nimeshpa 2013-11-21T21:31:39Z Calculated dimension + AGGR https://community.qlik.com/t5/QlikView/Calculated-dimension-AGGR/m-p/475342#M177514 <HTML><HEAD></HEAD><BODY><P>Is it possible to use an expression as calculated dimension when expression itself was calculated using AGGR as dimension. I want to use Decile as calculated dimension for further analysis. Expression behind the decile is&nbsp; ( I have attached the application for reference)</P><P></P><P>10-(div(((RangeSum(above(TOTAL sum(OrderCount),0,RowNo(TOTAL))))/sum(TOTAL OrderCount))*9.99999999999,1))</P><P></P><P>Can you help me create 'Decile' from this application as calculated dimension? Thanks. </P><P></P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/49413_pastedImage_1.png" style="width: 620px; height: 269px;" /></P></BODY></HTML> Thu, 21 Nov 2013 21:31:39 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension-AGGR/m-p/475342#M177514 nimeshpa 2013-11-21T21:31:39Z