topic Re: Generate a Number from Another Number and a % Value in QlikView https://community.qlik.com/t5/QlikView/Generate-a-Number-from-Another-Number-and-a-Value/m-p/110516#M754846 <HTML><HEAD></HEAD><BODY><P>It seems to be a simple math, like:</P><P></P><P>Value*100/PurgeChar(Percent, '%') as Desired</P></BODY></HTML> Wed, 26 Sep 2018 09:32:01 GMT tresB 2018-09-26T09:32:01Z Generate a Number from Another Number and a % Value https://community.qlik.com/t5/QlikView/Generate-a-Number-from-Another-Number-and-a-Value/m-p/110515#M754845 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I have the following requirement</P><P></P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Actual Value</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>%</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Desired Value</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Difference</TH></TR><TR><TD style="padding: 2px;">800</TD><TD style="padding: 2px;">80 %</TD><TD style="padding: 2px;">1000</TD><TD style="padding: 2px;">200</TD></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">83 %</TD><TD style="padding: 2px;">120</TD><TD style="padding: 2px;">20</TD></TR><TR><TD style="padding: 2px;">7</TD><TD style="padding: 2px;">70 %</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">50 %</TD><TD style="padding: 2px;">10 </TD><TD style="padding: 2px;">5</TD></TR></TBODY></TABLE><P></P><P>I would like to generate 'Desired Value' and&nbsp; 'Difference' using Actual Value and %</P><P></P><P></P><P></P><P>TIA</P><P>Sai.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Generate-a-Number-from-Another-Number-and-a-Value/m-p/110515#M754845 psk180590 2020-11-25T16:16:04Z Re: Generate a Number from Another Number and a % Value https://community.qlik.com/t5/QlikView/Generate-a-Number-from-Another-Number-and-a-Value/m-p/110516#M754846 <HTML><HEAD></HEAD><BODY><P>It seems to be a simple math, like:</P><P></P><P>Value*100/PurgeChar(Percent, '%') as Desired</P></BODY></HTML> Wed, 26 Sep 2018 09:32:01 GMT https://community.qlik.com/t5/QlikView/Generate-a-Number-from-Another-Number-and-a-Value/m-p/110516#M754846 tresB 2018-09-26T09:32:01Z