Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Aggregation to show a relative percentage to the total for only top 15 dealers

Hi All,

I have chart which filters top 15 dealers for a distributor which works fine. Now , I'm trying to get the relative percentage for those top 15 dealers against the total value of business for that Distributor.
For example ,

Distributor A  has made business for 1 Million dollars.
There are 66 Dealers for Distributor A who contributed to make 1 Million dollars
Now, When I filter the report for Top 15 Dealers with the help of "Dimension Limits " tab , Qlikview calculates the relative percentage against the sum of top 15 Dealers but I want to calculate the relative percentage for 1 Million dollars.

Please  show me a way to do this in QLikview .

Regards,

Arun