11 Replies Latest reply: Jun 26, 2015 5:19 AM by jagan mohan rao appala RSS

    How to use fields from another table as dimension?

      Hi all,

       

      I'm new to Qlik sense and I'm struggling with some concepts.

       

      The following screenshot contains part of my data model:

      data model.PNG

      As you can see Request is linked to Categories via CategoriesID

       

      Now I am trying to create a graph displaying the total amount of requests (tickets) per category . For obvious reasons I don't want to use the CategoriesID but the Category field instead.

       

      So far I have the following:

      graphs.PNG

      On the left hand side I use CategoriesID as dimension, on the right hand side I use Category as dimension. Both graphs use the same measure.

      I would expect that both graphs display the same (except from the labels), however the graph using Category doesn't work at all.

       

      Can someone explain what I'm doing wrong here?

      Thanks in advance!