1 Reply Latest reply: Aug 24, 2016 3:49 AM by Al a RSS

    basic question regarding lookup associations

    Al a

      I've spent three hours on this so far....so its time to ask for help....

      I have 20+ years with databases, SQL, schemas etc - but nothing with Qlik so this is a really basic question.

      Here's the problem. In database terms how do I get Qlik to use a lookup table to label the dimensions of my data?

       

      Example:

      Table Data - 25 records, maturity_code (value 1-4), other columns etc

      Table Lookup - 4 records, maturity_code (value 1-4), Maturity (text description)

       

      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.......