Divide on No Aggr cant show in line chart

[Mosfet]

hello 

I am trying to create a line chart showing below calculation

(Sum(Total_Invoice_Amount)/[USD Rate])

it is not working on line or bar chart. I need to divide sales amount for each country to get its USD amount and show it monthly trend. However the equation working in a normal table.

[martinpohl]

Hi,

is there a relation between Invoice_Amount and USD rate?

For example, if you calculate this for one line of your invoices, there could be many rates because the relationship is 1:n (one rate for each month eg). So be sure that there's a 1:1 relation -> onerate for one month or date.

Also, be careful that every line has a rate, Qlik can't calculate with null (no values).

I would suggest to map your rate into Invoice_Amount table eg by currency and month to each line.

Regards

[Mosfet]

Hi, thanks for your replay

I have a lot of currencies  and I added a table with USD rate per country associated in the data manger using currency, so each country could take its rate and divide on to it to get the USD value for all.

it is working fine in the table attached per month but it cannot preview in line or bar chart.

 

do you mean that I should associate the currency table on monthly level, I mean the Key to be "CurrMonth" in the tow tables ? not just only the currency

[Mosfet]

sorry here is the table per month and it is working fine