Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-09-12 10:12 AM

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

854 Views
0 Likes
0 Replies