Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Partial sum in Pivot table with AGGR

Hello,

I found a lot of discussions on the community around this problem, but couldnt still figure out my problem.

I have a pivot table with sales data for different countries over the years. For the Sales figure, the sales is multiplied by the exchange rate corresponding to the particular market to display the figure in Eur. The problem is with the subtotal, I need a subtotal in EUR.

I tried various combinations with aggr and Total ...

Find attached the dummy app.

Thanks a lot in advance!

Tags (4)
3 Replies
MVP & Luminary
MVP & Luminary

Re: Partial sum in Pivot table with AGGR

How about using just sum([Sales]*[exchange rate]) as expression?


talk is cheap, supply exceeds demand
MVP
MVP

Re: Partial sum in Pivot table with AGGR

What is meant by in EURO?

What is Sales*[Exchange Rate] ?

Are Sales in EURO or in Different Currency?

If they are in different currency then.. you can simply write SUM(Sales * [Exchange Rate])

Not applicable

Re: Partial sum in Pivot table with AGGR

Sorry forgot to mention, that the sales figures are in the local

currencies. and the exchange rate is to convert it to Euro.

So the expression for the sales is qum(sales) *

But it does not make sense to Sum up the total sales which are in different

currencies. I want to sum up the Sales values in Euro.