topic currency converter in QlikView

currency converter

Wed, 02 Mar 2011 14:41:36 GMT

has anyone managed to do a currency converter in QV?

oliver

currency converter

Miguel_Angel_Baeyens — Wed, 02 Mar 2011 15:06:05 GMT

Can you elaborate on the requirements?

A table From - To? Considering rate changes in time?

currency converter

Wed, 02 Mar 2011 15:15:56 GMT

Hi Oliver,

please have a look on this track:

http://community.qlik.com/media/p/76847.aspx

Maybe it´s helpful.

Good luck!

Rainer

currency converter

Wed, 02 Mar 2011 15:44:08 GMT

aha

got it!

SQL SELECT accounting_period as Day,SalesMan,Revenue_net,

Revenue_currency as CCY

FROM BRS2.dbo.Sales

where accounting_period>='01-jan-2010';

SQL SELECT *

FROM BRS2.dbo.vwTime;

SQL SELECT CCY,ConversionDate as Day,RateUSD

FROM BRS2.dbo.Exchange;

SELECT iso as ConvertRevenueCCY

FROM BRS2.dbo.CURRENCY ConvertRevenue;

SQL SELECT CCY as ConvertRevenueCCY,ConversionDate as Day,RateUSD as RateUSD2

FROM BRS2.dbo.Exchange;

due to the calling of Exchange twice (with two differing Rate field names) QV sorts the schema out well

and if you put a list box on with "Always One Selected Value" for ConvertRevenueCCY and then create a trigger on that list box to add "GBP" when the report opens (instead fo the first alphabetical currency)

then create a graph with an expression as

sum(Revenue_net*RateUSD/RateUSD2)

it works

can't see any way around calling tables many times through, you can just link in multiple times in SQL Server, at least QV starts calling them with numbers on the end

oh and still can't change the format of my X axis to MMM-YY 😞

currency converter

Wed, 02 Mar 2011 15:55:32 GMT

that seems like a web interface...tough to tell with personal edition

was looking to imitate what SSAS does in the wizard...turn local currencies into any currency necessary

done it though, once i got past the way QV works...it was easy

can't see why you can't edit the table joins that means your schema is either engineered for QV or you end up doing a lot of aliasing in the SQL