Bar Chart - Measure with division does not work

[#1]

Hello,

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

I have this table:

ID	Type	Breed
1	Man	None
2	Dog	None
3	Dog	Boxer
4	Man	None
5	Dog	Spaniel
6	Dog	Spaniel
7	Man	None
8	Man	None

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

[swuehl]

Qlik is case sensitive with regard to field names, try

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

[#3]

Thanks for your reply.

I tried:

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

But I don't get the correct results per breed.

[sfatoux72 · Accepted solution]

try these :

Count({$<type = {'Dog'}>} ID) / Count({$<type = {'Man'}>} Total ID )

[swuehl]

What would be correct results then?

Based on your sample table, you don't have type man for breeds Spaniel and boxer, so you divide by zero.

Breed None should return 1/4, right?

[brijesh1991]

Qlik Products are case-sensitive. So better to use the exact field names. Otherwise no issues at all.

[#7]

Hello,

Thanks a lot for your answer, it works great !

If I may, could I ask another question? I would like to add a dimension in order to show the evolution of the most popular breed across the years. How can I have the <Total Men> per year (and not summed on all the years) ?

Will the following work in a stacked bar chart ?

• Dimension1 : Year of Birth
• Dimension 2 : Breed
• Measure : Count({$<type = {'Dog'}>} ID) / Count({$<type = {'Man'}>} Total ID )

Many thanks

Annick

[swuehl]

You can use the TOTAL qualifier with a field list, so in your case, something like

Count( {$<type = {'Dog'}>} ID ) / Count({$<type = {'Man'}>} TOTAL<[Year of birth]> ID)

[sfatoux72]

‌Try like that :

Count({$<type = {'Dog'}>} ID) / Count({$<type = {'Man'}>} Total <[Year of Birth]> ID )

[#10]

Thank you so much !!! It works perfectly !