topic InputBox for currency convertation in QlikView https://community.qlik.com/t5/QlikView/InputBox-for-currency-convertation/m-p/787728#M278578 <HTML><HEAD></HEAD><BODY><P>Hi,guys!</P><P></P><P>I have a pivot table like:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 563pt;" width="752"><TBODY><TR style="height: 13.5pt;"><TD class="xl67" height="18" style="height: 13.5pt; width: 92pt;" width="123"> </TD><TD class="xl67" style="width: 80pt;" width="107"> </TD><TD class="xl68" style="border-left: none; width: 68pt;" width="91">Month</TD><TD class="xl69" style="border-left: none; width: 78pt;" width="104">Jan-15</TD><TD class="xl69" style="border-left: none; width: 48pt;" width="64">Jan-15</TD><TD class="xl69" style="border-left: none; width: 53pt;" width="71">Feb-15</TD><TD class="xl69" style="border-left: none; width: 48pt;" width="64">Feb-15</TD><TD class="xl69" style="border-left: none; width: 48pt;" width="64">Mar-15</TD><TD class="xl69" style="border-left: none; width: 48pt;" width="64">Mar-15</TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="height: 12.75pt; border-top: none;">Business Group</TD><TD class="xl64" style="border-top: none; border-left: none;">Employee</TD><TD class="xl65" style="border-left: none;">Main skill</TD><TD class="xl69" style="border-top: none;">Bench Salary</TD><TD class="xl69" style="border-top: none; border-left: none;">Bench FTE</TD><TD class="xl69" style="border-top: none; border-left: none;">Bench Salary</TD><TD class="xl69" style="border-top: none; border-left: none;">Bench FTE</TD><TD class="xl69" style="border-top: none; border-left: none;">Bench Salary</TD><TD class="xl69" style="border-top: none; border-left: none;">Bench FTE</TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; border-top: none;">International Other</TD><TD class="xl63" style="border-top: none; border-left: none;">Name 1</TD><TD class="xl66" style="border-top: none; border-left: none;">.NET</TD><TD class="xl71" style="border-top: none; border-left: none;">10000</TD><TD class="xl69" style="border-top: none; border-left: none;">1</TD><TD class="xl71" style="border-top: none; border-left: none;">10000</TD><TD class="xl69" style="border-top: none; border-left: none;">1</TD><TD class="xl71" style="border-top: none; border-left: none;">10000</TD><TD class="xl69" style="border-top: none; border-left: none;">1</TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; border-top: none;">International Other</TD><TD class="xl63" style="border-top: none; border-left: none;">Name 2</TD><TD class="xl66" style="border-top: none; border-left: none;">.NET</TD><TD class="xl71" style="border-top: none; border-left: none;">8000</TD><TD class="xl69" style="border-top: none; border-left: none;">0.8</TD><TD class="xl71" style="border-top: none; border-left: none;">10000</TD><TD class="xl69" style="border-top: none; border-left: none;">1</TD><TD class="xl71" style="border-top: none; border-left: none;">10000</TD><TD class="xl69" style="border-top: none; border-left: none;">1</TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; border-top: none;">International Other</TD><TD class="xl63" style="border-top: none; border-left: none;">Name 3</TD><TD class="xl66" style="border-top: none; border-left: none;">.NET</TD><TD class="xl71" style="border-top: none; border-left: none;">550</TD><TD class="xl69" style="border-top: none; border-left: none;">0.55</TD><TD class="xl69" style="border-top: none; border-left: none;">-</TD><TD class="xl69" style="border-top: none; border-left: none;">-</TD><TD class="xl69" style="border-top: none; border-left: none;">-</TD><TD class="xl69" style="border-top: none; border-left: none;">-</TD></TR></TBODY></TABLE><P></P><P>There are values in Bench Salary that can be eiher in USD or UAH. I want to create an InputBox where I'll write currency rates so the UAH values in the 'Bench Salary' field will be converted to USD. Any suggestions how to do that?</P></BODY></HTML> Wed, 25 Mar 2015 10:39:07 GMT 2015-03-25T10:39:07Z InputBox for currency convertation https://community.qlik.com/t5/QlikView/InputBox-for-currency-convertation/m-p/787728#M278578 <HTML><HEAD></HEAD><BODY><P>Hi,guys!</P><P></P><P>I have a pivot table like:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 563pt;" width="752"><TBODY><TR style="height: 13.5pt;"><TD class="xl67" height="18" style="height: 13.5pt; width: 92pt;" width="123"> </TD><TD class="xl67" style="width: 80pt;" width="107"> </TD><TD class="xl68" style="border-left: none; width: 68pt;" width="91">Month</TD><TD class="xl69" style="border-left: none; width: 78pt;" width="104">Jan-15</TD><TD class="xl69" style="border-left: none; width: 48pt;" width="64">Jan-15</TD><TD class="xl69" style="border-left: none; width: 53pt;" width="71">Feb-15</TD><TD class="xl69" style="border-left: none; width: 48pt;" width="64">Feb-15</TD><TD class="xl69" style="border-left: none; width: 48pt;" width="64">Mar-15</TD><TD class="xl69" style="border-left: none; width: 48pt;" width="64">Mar-15</TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="height: 12.75pt; border-top: none;">Business Group</TD><TD class="xl64" style="border-top: none; border-left: none;">Employee</TD><TD class="xl65" style="border-left: none;">Main skill</TD><TD class="xl69" style="border-top: none;">Bench Salary</TD><TD class="xl69" style="border-top: none; border-left: none;">Bench FTE</TD><TD class="xl69" style="border-top: none; border-left: none;">Bench Salary</TD><TD class="xl69" style="border-top: none; border-left: none;">Bench FTE</TD><TD class="xl69" style="border-top: none; border-left: none;">Bench Salary</TD><TD class="xl69" style="border-top: none; border-left: none;">Bench FTE</TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; border-top: none;">International Other</TD><TD class="xl63" style="border-top: none; border-left: none;">Name 1</TD><TD class="xl66" style="border-top: none; border-left: none;">.NET</TD><TD class="xl71" style="border-top: none; border-left: none;">10000</TD><TD class="xl69" style="border-top: none; border-left: none;">1</TD><TD class="xl71" style="border-top: none; border-left: none;">10000</TD><TD class="xl69" style="border-top: none; border-left: none;">1</TD><TD class="xl71" style="border-top: none; border-left: none;">10000</TD><TD class="xl69" style="border-top: none; border-left: none;">1</TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; border-top: none;">International Other</TD><TD class="xl63" style="border-top: none; border-left: none;">Name 2</TD><TD class="xl66" style="border-top: none; border-left: none;">.NET</TD><TD class="xl71" style="border-top: none; border-left: none;">8000</TD><TD class="xl69" style="border-top: none; border-left: none;">0.8</TD><TD class="xl71" style="border-top: none; border-left: none;">10000</TD><TD class="xl69" style="border-top: none; border-left: none;">1</TD><TD class="xl71" style="border-top: none; border-left: none;">10000</TD><TD class="xl69" style="border-top: none; border-left: none;">1</TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; border-top: none;">International Other</TD><TD class="xl63" style="border-top: none; border-left: none;">Name 3</TD><TD class="xl66" style="border-top: none; border-left: none;">.NET</TD><TD class="xl71" style="border-top: none; border-left: none;">550</TD><TD class="xl69" style="border-top: none; border-left: none;">0.55</TD><TD class="xl69" style="border-top: none; border-left: none;">-</TD><TD class="xl69" style="border-top: none; border-left: none;">-</TD><TD class="xl69" style="border-top: none; border-left: none;">-</TD><TD class="xl69" style="border-top: none; border-left: none;">-</TD></TR></TBODY></TABLE><P></P><P>There are values in Bench Salary that can be eiher in USD or UAH. I want to create an InputBox where I'll write currency rates so the UAH values in the 'Bench Salary' field will be converted to USD. Any suggestions how to do that?</P></BODY></HTML> Wed, 25 Mar 2015 10:39:07 GMT https://community.qlik.com/t5/QlikView/InputBox-for-currency-convertation/m-p/787728#M278578 2015-03-25T10:39:07Z