topic Using TOTAL to get % all Data in QlikView

Using TOTAL to get % all Data

zagzebski — Tue, 14 Oct 2014 16:05:59 GMT

Below I have the data and result I am looking for. I can't figure out how to get the column: All Groups % of Total. This column takes revenue by area for ALL groups divided by total revenue for all groups and all areas. (Example for "North"...All north revenue is 60 and all revenue is 360...thus it is 17%)

DATE:
Group	Area	Revenue
1	North	10
1	South	20
1	East	30
1	West	40
2	North	50
2	South	60
2	East	70
2	West	80
RESULT (filtered on Group 1):
Group	Area	Revenue	All Groups by Area	All Groups % of Total
1	North	10	60	17%
1	South	20	80	22%
1	East	30	100	28%
1	West	40	120	33%
		100	360	100%

Re: Using TOTAL to get % all Data

JonnyPoole — Tue, 14 Oct 2014 16:10:59 GMT

There is a checkbox on the expressions tab called 'relative' .

Try copying and pasting your 2nd expression into a 3rd expression and this time enabling the relative checkbox.

Here is a screenshot with an example:

1st expression is just current selections (ASIA)

2nd expression is same but shows for all regions

3rd is same as 2nd with 'relative' checked

Re: Using TOTAL to get % all Data

zagzebski — Tue, 14 Oct 2014 17:25:42 GMT

Thanks! Too simple!

Re: Using TOTAL to get % all Data

JonnyPoole — Tue, 14 Oct 2014 17:26:27 GMT

haha. was using the tool 3 years before someone showed me there was actually a shortcut works well when there is only 1 dimension.