topic different aggregation with different dimension in QlikView https://community.qlik.com/t5/QlikView/different-aggregation-with-different-dimension/m-p/193341#M54649 <HTML><HEAD></HEAD><BODY><P>I am have the following data set</P><P>fund, sector instrument_symbol, date,position</P><P>1, energy, GOOG,1/1/11, 30.56</P><P>1, energy, GOOG,1/2/11, 29.56</P><P>1, energy, GOOG,1/1/11, 30.56</P><P>1, energy, GOOG,1/1/11, 29.56</P><P>1, tech, IBM,1/1/11, -50.5</P><P>3, energy, MSFT, 3/2/11, 29.56</P><P>3, energy, GOOG, 3/2/11, 19.01</P><P>How do I create a pivotable that 1) when it aggregate the position on fund sector instrument level it will keep the decimial (no rounding) and 2) when it aggregate on the fund sector level it will round the aggregated position to the nearest integer. 3) When it round anything above the sector level (ie fund) it will aggregate using the rounded position from the fund sector aggregation?</P><P></P><P>I can get 1 and 2 working with aggr and dimensionality but not 3</P></BODY></HTML> Thu, 31 Mar 2011 19:55:13 GMT 2011-03-31T19:55:13Z different aggregation with different dimension https://community.qlik.com/t5/QlikView/different-aggregation-with-different-dimension/m-p/193341#M54649 <HTML><HEAD></HEAD><BODY><P>I am have the following data set</P><P>fund, sector instrument_symbol, date,position</P><P>1, energy, GOOG,1/1/11, 30.56</P><P>1, energy, GOOG,1/2/11, 29.56</P><P>1, energy, GOOG,1/1/11, 30.56</P><P>1, energy, GOOG,1/1/11, 29.56</P><P>1, tech, IBM,1/1/11, -50.5</P><P>3, energy, MSFT, 3/2/11, 29.56</P><P>3, energy, GOOG, 3/2/11, 19.01</P><P>How do I create a pivotable that 1) when it aggregate the position on fund sector instrument level it will keep the decimial (no rounding) and 2) when it aggregate on the fund sector level it will round the aggregated position to the nearest integer. 3) When it round anything above the sector level (ie fund) it will aggregate using the rounded position from the fund sector aggregation?</P><P></P><P>I can get 1 and 2 working with aggr and dimensionality but not 3</P></BODY></HTML> Thu, 31 Mar 2011 19:55:13 GMT https://community.qlik.com/t5/QlikView/different-aggregation-with-different-dimension/m-p/193341#M54649 2011-03-31T19:55:13Z