0 Replies Latest reply: Apr 21, 2015 9:42 PM by Mike Fitzgerald RSS

    Dynamic Set Analysis Modifier

      Hi all,

       

      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:

       

      FirstSortedValue({1<MarketCapBands=P(MarketCapBands)>} vMarketCapCurrent, key_company_id)

       

      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.

       

      Any suggestions would be appreciated and tried.

       

      Thank you!