Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
ilanbaruch
Contributor III

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.