topic Re: Distribution - Calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/Distribution-Calculated-Dimension/m-p/593054#M477239 <HTML><HEAD></HEAD><BODY><P>maybe in the attachment</P></BODY></HTML> Sun, 04 May 2014 15:43:52 GMT maxgro 2014-05-04T15:43:52Z Distribution - Calculated Dimension https://community.qlik.com/t5/QlikView/Distribution-Calculated-Dimension/m-p/593053#M477238 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am trying to create a distribution graph that shows the number (distinct) of clients with a certain Average $/Kg, eg number of farmers between 2.0 and 2.5, farmers between 2.5 and 3.0 etc. I have attached a spreadsheet with some dummy data. I am not sure about the scripting for the calculated dimension. Average $/Kg is Value($)/Kgs. Please also note that each client may have more than one transaction.</P><P></P><P>Any assistance appreciated.</P><P></P><P>Herbiec</P></BODY></HTML> Sun, 04 May 2014 14:24:25 GMT https://community.qlik.com/t5/QlikView/Distribution-Calculated-Dimension/m-p/593053#M477238 2014-05-04T14:24:25Z Re: Distribution - Calculated Dimension https://community.qlik.com/t5/QlikView/Distribution-Calculated-Dimension/m-p/593054#M477239 <HTML><HEAD></HEAD><BODY><P>maybe in the attachment</P></BODY></HTML> Sun, 04 May 2014 15:43:52 GMT https://community.qlik.com/t5/QlikView/Distribution-Calculated-Dimension/m-p/593054#M477239 maxgro 2014-05-04T15:43:52Z Re: Distribution - Calculated Dimension https://community.qlik.com/t5/QlikView/Distribution-Calculated-Dimension/m-p/593055#M477240 <HTML><HEAD></HEAD><BODY><P>Perfect Massimo,</P><P></P><P>Thank you very much, exactly what I needed.</P><P></P><P>Much appreciated</P><P></P><P>H</P></BODY></HTML> Sun, 04 May 2014 16:27:24 GMT https://community.qlik.com/t5/QlikView/Distribution-Calculated-Dimension/m-p/593055#M477240 2014-05-04T16:27:24Z