7 Replies Latest reply: Sep 17, 2015 9:59 AM by Alberto Segovia RSS

    Circular references...

      Hello everyone! I'm new not only to Qlik but to the world of databases or even data... and I'm going to show you right now :-)

       

      So that's my model. To simplify, let's say every row in "DATA" has:

      - one responsible (Username)

      - one list of delegated people (many TO_USER_NAME).

       

      I want to play with that info in my sheets. And I basically need the "FULL_USER_NAME" for everyone. My solution? Linking what I highlight in yellow. My problem? It creates a circular reference.

       

      I can't change the database, that's out of question. What would be a way to show this?

       

      Thank you!!!!!!!!!