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
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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?

434 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.
362 Views
0 Likes