Country Wise Sales to particular currency

[#1]

HI all,

I am very new to the  QlikView and i have stucked with the below requirement.

When I select Country, I will automatically get all data belongs to that particular country according to their Currency.

For Example i have a list box(Country) and straight table(country(dim) and SUM(SALES)),

when i select Country India it should show the sales according to the india Sales ,for US($) sales etc.....

Kindly help me on above requirement.

Thanks,

[#2]

Hi Sruthi,

Create 1 more field like exchange rate against Country

And IN Expression, You can give like

sum(sales)* exchange rate

Warm Regards,

Joshmi

[#3]

Hi Sruthi,

You need to load an extra table with the currency inside your model.

LOAD * INLINE [

CUR, VAL

$, 10

£, 14];

Then link the CUR to the sales table.

Then all you do is sum(Sales) * VAL

Regards,
Marius

[hariprasadqv · Accepted solution]

better to take a variable and assign exchange rate to it and multiply play exchange rate with it. it would be the good practice.

Ex:

Let vRate=62.30;

Add expression for an additional column like sum(sales)*vRate;

It will gives you desired output.

[PradeepReddy]

if u want to to achieve this,

you have to take all sales in same currency and after that try as suggested by Joshmi.

[hariprasadqv]

When multiple currencies are there it is better to create currency and its exchange rate table or supplying the exchange rate through Input Box object is also a good one.

[PradeepReddy]

Currency Conversion

[#8]

HI Marius,

     Thank for revert back to me,I have a small doubt when the Conversion rates  changes daily. For example, last month  $ price is 62.30 and for this $ rate 55.71 . How should i compare these calculations.Plz Help me.

Regards,

Sruthi

[#9]

hi prasad,

Thank's for your reply,but my question is, i have straight table  with product wise sales.

i have a list box like country,when i click on india it should show me indian currency sales  of different products,

when i click on US it should show me US currency . Plz Help me

regards,

sruthi