Forum Discussion

jadewind's avatar
jadewind
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Error: Can't determine relationships between the fields

 

I have been trying to display a table with two fields: Person and Items by using above model. However the visual cannot displayed due to subject error. How can I make it work?

Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi jadewind

     

    Is it not possible to combine the Age Cateogry, Age and P tables together using the Query Editor?

    This will then allow you to view the data the way you want?

7 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Icon for Super User rankSuper User
    9 years ago

    You should set the relationships between Age and Age Category Bidirectional. This way it allows the filter from Age to propogate towards age category.

    • jadewind's avatar
      jadewind
      Icon for Advocate I rankAdvocate I
      9 years ago

      Thanks for your prompt reply BhaveshPatel. I have tried that and it doesn't work. I have also tried bidirections on other relationships and couldn't make it work either. So below is the relationship now, and the visual I wish to display:

      Anything else I can try?

       

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        9 years ago

        Hi jadewind

         

        Is it not possible to combine the Age Cateogry, Age and P tables together using the Query Editor?

        This will then allow you to view the data the way you want?