Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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!

Dimensionhelp.PNG

0 Replies