Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
New 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.


%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
New Contributor III

Re: Percent of subtotals as well as totals

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

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