topic Evolution rate as a calculated dimension in QlikView https://community.qlik.com/t5/QlikView/Evolution-rate-as-a-calculated-dimension/m-p/331170#M576440 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>First of all I am a beginner.</P><P></P><P>Let say that we have a table with 6 fields : Customer, customer familly, ,order number, year,&nbsp; Sales, gross margin</P><P>The goal is to produced a bubble chart having as axis : Turnover increase rate (Selected year versus the year before), gross margin rate (gross margin / sales)</P><P>The bubble should represent the gross margin value., for a given customer </P><P>The chart should change if a customer familly is selected or changed</P><P></P><P>I have struggled a little bit with nested agreagation (aggr), and must adminted that i could make it work.</P><P></P><P>Must be classic and stupid</P><P></P><P>Many thanks in advance.</P><P></P><P>Lionel</P></BODY></HTML> Sun, 01 Apr 2012 19:08:09 GMT 2012-04-01T19:08:09Z Evolution rate as a calculated dimension https://community.qlik.com/t5/QlikView/Evolution-rate-as-a-calculated-dimension/m-p/331170#M576440 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>First of all I am a beginner.</P><P></P><P>Let say that we have a table with 6 fields : Customer, customer familly, ,order number, year,&nbsp; Sales, gross margin</P><P>The goal is to produced a bubble chart having as axis : Turnover increase rate (Selected year versus the year before), gross margin rate (gross margin / sales)</P><P>The bubble should represent the gross margin value., for a given customer </P><P>The chart should change if a customer familly is selected or changed</P><P></P><P>I have struggled a little bit with nested agreagation (aggr), and must adminted that i could make it work.</P><P></P><P>Must be classic and stupid</P><P></P><P>Many thanks in advance.</P><P></P><P>Lionel</P></BODY></HTML> Sun, 01 Apr 2012 19:08:09 GMT https://community.qlik.com/t5/QlikView/Evolution-rate-as-a-calculated-dimension/m-p/331170#M576440 2012-04-01T19:08:09Z