topic expression in QlikView https://community.qlik.com/t5/QlikView/expression/m-p/852934#M999128 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>a simple question (I hope)</P><P></P><P>Using expression, is it posible divide a value?</P><P></P><P>How <SPAN style="font-size: 10pt; line-height: 1.5em;">to do it?</SPAN></P><P></P><P>Example</P><P>field: invoice_number</P><P>files: total_value</P><P>new fields: Total_value / (count(invoice_number))</P></BODY></HTML> Thu, 18 Jun 2015 12:21:33 GMT fmazzarelli 2015-06-18T12:21:33Z expression https://community.qlik.com/t5/QlikView/expression/m-p/852934#M999128 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>a simple question (I hope)</P><P></P><P>Using expression, is it posible divide a value?</P><P></P><P>How <SPAN style="font-size: 10pt; line-height: 1.5em;">to do it?</SPAN></P><P></P><P>Example</P><P>field: invoice_number</P><P>files: total_value</P><P>new fields: Total_value / (count(invoice_number))</P></BODY></HTML> Thu, 18 Jun 2015 12:21:33 GMT https://community.qlik.com/t5/QlikView/expression/m-p/852934#M999128 fmazzarelli 2015-06-18T12:21:33Z Re: expression https://community.qlik.com/t5/QlikView/expression/m-p/852935#M999129 <HTML><HEAD></HEAD><BODY><P>In general, you shold use aggregation functions around every field in an expression.</P><P></P><P>Maybe like</P><P>=SUM(Total_value) / COUNT(invoice_number)</P></BODY></HTML> Thu, 18 Jun 2015 12:24:50 GMT https://community.qlik.com/t5/QlikView/expression/m-p/852935#M999129 swuehl 2015-06-18T12:24:50Z Re: expression https://community.qlik.com/t5/QlikView/expression/m-p/852936#M999130 <HTML><HEAD></HEAD><BODY><P>!Hello Fabio, attached an simple example, maybe you help</P></BODY></HTML> Thu, 18 Jun 2015 12:28:51 GMT https://community.qlik.com/t5/QlikView/expression/m-p/852936#M999130 PabloOrtiz 2015-06-18T12:28:51Z Re: expression https://community.qlik.com/t5/QlikView/expression/m-p/852937#M999131 <HTML><HEAD></HEAD><BODY><P><IMG alt="Immagine.png" class="jive-image image-1" height="217" src="https://community.qlik.com/legacyfs/online/89937_Immagine.png" style="height: 217px; width: 401.611940298507px;" width="402" /></P><P>hi, your suggest is fine.</P><P></P><P>but if i create a chart (digital display), I obtain this result?</P><P></P><P>What is it wrong?</P></BODY></HTML> Thu, 18 Jun 2015 13:45:26 GMT https://community.qlik.com/t5/QlikView/expression/m-p/852937#M999131 fmazzarelli 2015-06-18T13:45:26Z Re: expression https://community.qlik.com/t5/QlikView/expression/m-p/852938#M999132 <HTML><HEAD></HEAD><BODY><P>The expression itself is working e.g. in a text box?</P><P></P><P>Can you upload a small QVW sample file?</P></BODY></HTML> Thu, 18 Jun 2015 13:55:02 GMT https://community.qlik.com/t5/QlikView/expression/m-p/852938#M999132 swuehl 2015-06-18T13:55:02Z Re: expression https://community.qlik.com/t5/QlikView/expression/m-p/852939#M999133 <HTML><HEAD></HEAD><BODY><P>thanks for your suggest.</P><P>It's works</P></BODY></HTML> Thu, 18 Jun 2015 20:19:52 GMT https://community.qlik.com/t5/QlikView/expression/m-p/852939#M999133 fmazzarelli 2015-06-18T20:19:52Z