Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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.