topic Re: using aggr() in calculated dimension in QlikView

using aggr() in calculated dimension

Tue, 15 Jul 2014 08:22:14 GMT

Hi all,

I load an unit cost table to qvw by year, company, product and orginal_currency

and another rate table by year, month,original currency, reporting currency.

I created 2 aggr() in 2 individual calcuated dimension :

1. aggr(distinct(cost),year,company,product,orginal_currency)

2. aggr(max({<reporting_currency={'JPY'}>}rate), year, month,company,product,orginal_currency)

My question is if it's possible to create a new calculated dimension which is (1 * 2) .

Thanks,

Catherine

Anonymous — Tue, 15 Jul 2014 08:34:46 GMT

Hi,

You can add new dimension with calculated form (1*2) or just in text (one) or number (1) form.

Tue, 15 Jul 2014 09:04:18 GMT

Sorry. My meaning is to add new dimension that multiply below 2 aggr() values Cost * Rate :

1. aggr(distinct(cost),year,company,product,orginal_currency)

2. aggr(max({<reporting_currency={'JPY'}>}rate), year, month,company,product,orginal_currency)