2 Replies Latest reply: Aug 27, 2018 7:28 PM by Myka Crizielle Danila RSS

    By Manufacturer Market Share in a specified Segment

    Myka Crizielle Danila

      Hi,

       

      I have a total market that is divided into 2 segments: Segment A and Segment B. Now I want to show the development of market shares of the manufacturers in Segment A in a line Chart like below:

       

      Market Share Line Charts.PNG

       

      In Qlik Sense, I have made a line chart with the Dimensions:Time Period, Manufacturer, Measures:

      =sum({$<Segmentation={'A'}>} ConvertedUnit)/sum({$<Segmentation={'A'}>*1<Manufacturer=>} ConvertedUnit)

       

      But it doesn't work. It gives me 100% share for each manufacturer because it is dividing it by itself when what I want to happen is:

       

      (Manufacturer 1 Converted Units in Segment A)/(Total Converted Units in Segment A)

       

      I also tried using the Total function but it includes  the converted units in Segment B.

       

      Thanks for your help!

       

      Myka