topic Re: Div function always results Zero when denominator is greater than numerator in QlikView https://community.qlik.com/t5/QlikView/Div-function-always-results-Zero-when-denominator-is-greater/m-p/1190135#M883714 <HTML><HEAD></HEAD><BODY><P>Thansk, this is helpful. </P></BODY></HTML> Tue, 27 Sep 2016 04:05:08 GMT 2016-09-27T04:05:08Z Div function always results Zero when denominator is greater than numerator https://community.qlik.com/t5/QlikView/Div-function-always-results-Zero-when-denominator-is-greater/m-p/1190133#M883712 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am using "straight table" chart which has couple of columns. For one column I am using the expression like</P><P>Div(value_numerator, value_denominator).</P><P></P><P>Div(3,8) gives me '0' and not 0.375</P><P></P><P>I need the values in % format. So I can do, Div(value_numerator * 100, value_denominator), but when I select 'Show in Percent' in 'Number' tab in the properties, it again multiply my result with 100 giving 3750%. All I need is 37.5%.</P><P></P><P>Thanks in advance for your help.</P><P></P><P>-Harkumar</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Div-function-always-results-Zero-when-denominator-is-greater/m-p/1190133#M883712 2020-11-25T16:16:04Z Re: Div function always results Zero when denominator is greater than numerator https://community.qlik.com/t5/QlikView/Div-function-always-results-Zero-when-denominator-is-greater/m-p/1190134#M883713 <HTML><HEAD></HEAD><BODY><P>The help file says </P><P>"<STRONG>Integer division</STRONG>. Both parameters are interpreted as real numbers, i.e. they do not have to be integers. The result is the <STRONG>integer</STRONG> part of the result of the arithmetic division, a real number. "</P><P></P><P>Why not just do A/B?</P></BODY></HTML> Thu, 22 Sep 2016 16:07:24 GMT https://community.qlik.com/t5/QlikView/Div-function-always-results-Zero-when-denominator-is-greater/m-p/1190134#M883713 m_woolf 2016-09-22T16:07:24Z Re: Div function always results Zero when denominator is greater than numerator https://community.qlik.com/t5/QlikView/Div-function-always-results-Zero-when-denominator-is-greater/m-p/1190135#M883714 <HTML><HEAD></HEAD><BODY><P>Thansk, this is helpful. </P></BODY></HTML> Tue, 27 Sep 2016 04:05:08 GMT https://community.qlik.com/t5/QlikView/Div-function-always-results-Zero-when-denominator-is-greater/m-p/1190135#M883714 2016-09-27T04:05:08Z