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.