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!
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?
