Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
zagzebski
Contributor

Using TOTAL to get % all Data

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:
GroupAreaRevenue
1North10
1South20
1East30
1West40
2North50
2South60
2East70
2West80
RESULT
  (filtered on Group 1):
GroupAreaRevenueAll Groups by AreaAll Groups % of Total
1North106017%
1South208022%
1East3010028%
1West4012033%
    100360100%
Tags (2)
1 Solution

Accepted Solutions
Employee
Employee

Re: Using TOTAL to get % all Data

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

Capture.PNG.png

3 Replies
Employee
Employee

Re: Using TOTAL to get % all Data

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

Capture.PNG.png

zagzebski
Contributor

Re: Using TOTAL to get % all Data

Thanks! Too simple!

Employee
Employee

Re: Using TOTAL to get % all Data

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