So I want to create a simple bar chart that counts how many times each value of maturity_code is found in Data - and labelled using the Maturity text. In my old DB world - that's a SQL join - in Qlik its an association.
So I have an association between data.maturity_code and lookup.maturity_code - so far so good.
If I choose Bar chart:
- dimensions = maturity
- measures = maturity_code
I get four bars labelled with the text from maturity - each with a value of 1. ie Qlik is listing the four text maturity values - and counting them once.....each time they appear in the lookup table.
How do I make Qlik count the number of times each maturity_code appears in the Data table?
I know its simple and I know its obvious and I know I am probably going to get roasted here but I cant see it.......