How to add the right dimension/misure

[Marcoqlikism2019]

Hi,
I'm new at Qlik Sense. I've got a simple question.
Let's suppose I have a table BOOK with colmuns TITLE, ID_LANGUAGE and a table LANGUAGE with columns ID_LANGUAGE and DESC_LANGUAGE.
BOOK is the fact table and LANGUAGE is a dimension table.
After loading the two tables from flat files and defining the recommended association (of course by ID_LANGUAGE), I have tried to create the misure count(ID_LANGUAGE). The problem is that when I try to create a new sheet for creating an histogram reporting for every language the number of books written in that language I don't know how to do for using the association so as to get something like this:
ENGLISH 50
SPANISH 24
FRANCH 21
bacause I get only
1 50
2 24
3 21
where 1,2,3 are the ID_LANGUAGE whereas I'd like to get the grouping by DESC_LANGUAGE
Thanks in advance!

Mark

[rwunderlich]

Do not try to count Key fields. Instead:

Use LANGUAGE for the DImension.

Use Count(TITLE) for the Measure.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[Marcoqlikism2019]

Thank you Rob,

but maybe I haven't understood. I've already got LANGUAGE as table and I've created the assotiacion ASS_LANGUAGE that joins BOOK and LANGUAGE by ID_LANGUAGE. Do I have to create a dimension but how?

[rwunderlich]

You do not have to create a Dimension.  You can use the Field LANGUAGE as your dimension in the table chart.

-Rob