9 Replies Latest reply: Mar 4, 2016 2:47 AM by annick whitfield RSS

    Bar Chart - Measure with division does not work

    annick whitfield

      Hello,

       

      I am a newbie in Qlik Sense and would really need your help.

       

      I have this table:

      IDTypeBreed
      1ManNone
      2DogNone
      3DogBoxer
      4ManNone
      5DogSpaniel
      6DogSpaniel
      7ManNone
      8ManNone

       

       

      I would like to show, per breed, the number of dogs divided by the number of men (Imagine we're looking for the most popular breed based on how many people owns them) :

       

       

       

       

       

      I use a bar chart with :

       

       

      • Dimension : breed
      • Measure : Count({$<type = {'Dog'}>} ID) / Count({$<type = {'Man'}>} ID ) 

        

        But it does not work...

       

      Many thanks in advance for your help.

      Annick