Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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


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
Highlighted
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)