topic Divide on No Aggr cant show in line chart in App Development

Divide on No Aggr cant show in line chart

Mosfet — Thu, 15 Sep 2022 11:01:00 GMT

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.

Re: Divide on No Aggr cant show in line chart

martinpohl — Thu, 15 Sep 2022 11:15:06 GMT

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

Re: Divide on No Aggr cant show in line chart

Mosfet — Thu, 15 Sep 2022 15:23:13 GMT

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

Re: Divide on No Aggr cant show in line chart

Mosfet — Thu, 15 Sep 2022 15:25:01 GMT

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