Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Calculate top 10 vs total in staright table

Hi Community

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 and show that may be in a text box next to the table

can someone please suggest how to do it?

4 Replies
Highlighted
Master II
Master II

Re: Calculate top 10 vs total in staright table

please share a small sample qvw with some sample data to work....

Highlighted
Contributor III
Contributor III

Re: Calculate top 10 vs total in staright table

I am attaching an excel with the data set.

It contains year over year comparison for sale of each customer. i have a straight table that shows 2019, 2020 sales and YoY change and the table  shows top 10 customers based on Year over year change. the second set shows total data.

What i want to do is calculate the percentage of top 10 year over year change vs total sales of 2020

(Sum of top 10 YoY change)/(Total sales in 2020)

Highlighted
Master II
Master II

Re: Calculate top 10 vs total in staright table

see attached

Highlighted
Contributor III
Contributor III

Re: Calculate top 10 vs total in staright table

Thanks for you reply, but this does not solve my issue. my fault actually as i was not clear earlier.

i have the data for 2019 and 2020 combined. then i use aggr function for splitting them into column by year and then i calculate Year over Year change. Your solution assumes the year data is separated which it is not.