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: 
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
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: 
Jagveer
Contributor III
Contributor III
‎2020-04-22 02:49 PM

Need to store top 10 sum from a table into a variable to be used for calculation

HI,

 

i have a staright table which displays top 10 value for a combination of 2 dimensions (the dimensions are hierarchical).

now i want to calculate the percentage of these top 10 vs the total value.

can someone please suggest how to do it?

443 Views
0 Likes
1 Reply
Brett_Bleess
Former Employee
Former Employee
‎2020-05-19 05:16 PM

Believe you would need to use Set Analysis, hopefully the following link may get you on the right track:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Just realized you may need this one too:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
371 Views
0 Likes