Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
the_murkle_man
Contributor II
Contributor II
‎2016-01-18 10:54 AM

Percentage of SubTotal

Hi Guys,

I have recently been stumped trying to figure out how to create a % of a sub total.

For example I have a pivot table showing something like this:

County     City     Count of Sales

UK           London          10

UK           Liverpool        15

UK           Manchester    75

France     Paris              90

France     Nice               10         

So for the UK I would like to have another column saying 10% for London, 75% for Manchester etc.

I have been trying to create this in Set Analysis using the Aggr function, however it always uses the total of the entire pivot table, not the sub totals!

Any support would be massively appreciated!

Regards

9,389 Views
0 Likes
11 Replies
Anonymous
Not applicable
‎2017-09-20 04:58 AM

In response to ThornOfCrowns

Hi, do you have this for Qliksense as nothing appears when I load it thus it might be just for QV?

381 Views
0 Likes
Anonymous
Not applicable
‎2017-11-08 09:24 AM

In response to senpradip007

Hi Sen,

I am encountering the same kind issue.Will you be able to paste the formulated columns in this discussion page,

because i am not able to open the qvw file

381 Views
0 Likes