topic Re: Forex Inverse Issue in QlikView

Forex Inverse Issue

tracycrown — Thu, 22 Jan 2015 03:09:24 GMT

Dear all

Kindly help to advise the following issues :

1. How to keep the answer in Table 1 as it disappears after clicking Euro currency ?

2. Have problem in getting the correct answer as Table 2 in Excel.

Thank You Very Much

Tracy

Re: Forex Inverse Issue

francoiscave — Thu, 22 Jan 2015 09:24:34 GMT

Hi Tracy,

See the attached file to get the solution.

It's what do you expect ?

Best regards,

François

Re: Forex Inverse Issue

Gysbert_Wassenaar — Thu, 22 Jan 2015 10:01:13 GMT

See attached qvw. Is that what you mean?

Re: Forex Inverse Issue

tracycrown — Thu, 22 Jan 2015 13:02:43 GMT

Dear François

Thanks for your quick response and help.

You have answered the 1st question but not the 2nd one, The answer for the 2nd one is shown in the Excel worksheet called "Answer").

Thank You

Tracy

Re: Forex Inverse Issue

tracycrown — Thu, 22 Jan 2015 13:07:31 GMT

Dear Gysbert Wassenaar

Many thanks for your help and quick response.

The answer is correct but can you explain why there is a fixed date in sum({<Date={'01-01-15'}>}Data) in vCurr. Can I have some flexibility ?

Thank You

Tracy

Re: Forex Inverse Issue

Gysbert_Wassenaar — Thu, 22 Jan 2015 13:19:43 GMT

Because you do the same kind of thing in the excel file. If you want flexibility you can use a variable instead of the fixed value.

Re: Forex Inverse Issue

tracycrown — Thu, 22 Jan 2015 14:13:31 GMT

Dear Gysbert Wassenaar

Sorry, it is my mistake, I have changed from fixed to variable in the revised worksheet.

Kindly advise how to change the script and allow me to choose any currency (not just Euro).

Thank You

Tracy

Re: Forex Inverse Issue

Gysbert_Wassenaar — Thu, 22 Jan 2015 14:21:04 GMT

Click on a currency value to select it.

Re: Forex Inverse Issue

tracycrown — Thu, 22 Jan 2015 23:52:32 GMT

Dear Gysbert Wassenaar

I know I have to select the currency but how to change the vCur to cater for all dates instead of fixed date '01-01-15'.

Thank You

Tracy

Re: Forex Inverse Issue

Gysbert_Wassenaar — Fri, 23 Jan 2015 10:35:52 GMT

See attached qvw