Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

InputBox for currency convertation

Hi,guys!

I have a pivot table like:

MonthJan-15Jan-15Feb-15Feb-15Mar-15Mar-15
Business GroupEmployeeMain skillBench SalaryBench FTEBench SalaryBench FTEBench SalaryBench FTE
International OtherName 1.NET100001100001100001
International OtherName 2.NET80000.8100001100001
International OtherName 3.NET5500.55----

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?

Labels (1)
0 Replies