topic Re: issue in calculation in script in QlikView

issue in calculation in script

Anonymous — Wed, 22 Jun 2016 11:41:48 GMT

Dear Friends

We have some fields like Amount, rate and tax_amount in different currencies. If we multiply amount and tax_amount with rate

we get the corresponding amount in local currency.

We are doing this in script itself as sum(Amount) * rate and sum(tax_amount) * rate.

We are then taking group by of the remaining dimensions. However we are not getting the correct data for all transactions.

We also tried amount * rate but it is giving incorrect data.

Kindly help if you have any suggestions. Thanks in advance.

Thanks & Regards

Chintan

Anonymous — Wed, 22 Jun 2016 15:20:26 GMT

Hi Chintan,

Could you share some example of your data and app please?

Regards!

marcus_sommer — Wed, 22 Jun 2016 15:46:26 GMT

Give something like this a try: sum(Amount * rate)

- Marcus

trdandamudi — Wed, 22 Jun 2016 15:48:22 GMT

It will be nice if you share some sample data, so that we can take a look and come up with a solution.