I have several Qlik Sense charts where I wish to display a company with their financial peers, such as Market Cap peers. I wish to select a company (the chart dimension [CompanyName]) and see the selected company and the companies that lie within 10% either side of the selected companies Market Cap. By hardcoding the Market Cap bands into a separate table I was able to get this to work with this expression:
I would prefer to make the range dynamic based on the vMarketCapCurrent field (one to one with companies), by including in the displayed set, companies whose vMarketCapCurrent lies within 10% above and below the current selected company. I have tried several methods but no success as yet.