Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

ilanbaruch
Contributor II

Total

Hi All,

I'm trying to calculate relative amount (pivot table) with excluded dimension :

sum(amount) / sum(TOTAL <item_name> amount)

but result comes as :

sum((amount)/sum(TOTAL amount)

any ideas?


2 Replies
sasiparupudi1
Honored Contributor III

Re: Total

try

aggr(sum((amount)/sum(TOTAL amount) ,yourdimension)

MVP
MVP

Re: Total

Ideas could be directed to the right direction, if you could attach your sample qvw.

Community Browser