Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
imac
Contributor II
Contributor II

Percent of subtotals as well as totals

Hi everyone, new to Qlikview and am hoping someone can point me in the right direction

I am trying to do a pivot chart needs to look like this. I have Branch & Rating (Very High, High etc) as dimensions in my table, and Volume is the measure.

ALL is the partial sum on Rating and ASIA is my partial sum on Branch.


Capture.PNG

%Branch is the value for sum of the row of each Branch / each volume. %Region is the volume of the branch / total for ASIA. 

There are two things I am struggling with

- I am not able to figure out how to do %Region but I figure out how to do %Branch as sum(volume)/sum(total volume)

- For the last column ALL I need to suppress %Branch, that is, not show that column as it will be 100% all the time so pointless to have it there, but Qlikview does not give me an option to hide it, unless I missed it.

Any help appreciated!

Labels (1)
1 Reply
tanjavarwijk
Contributor III
Contributor III

- Find the button relative when you make the expression (for %Region)

- Find the button subtotals in tab presentation (for ALL solution)