Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Using dimension limit totals

So I have an issue trying to use dimension totals in expressions. I basically want to calculate the % split between home and store for each "name" dimension.  As you can see in "Named total" I get the correct total, but it will only show for one of the HD dimensions - this happens for all names, there is a total but it only populates either HD or STORE.

Using the total function in my aggr fills everything with the £4million total value, I want the £181k!

I need this to populate both fields so I can divide it by the value to get % split of Value in Agricultural (and subsequent dimensions).

Please help!