Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Table (visual) returns blank result

Hi

 

My situation: 

 

Table A has multiple columns including column "Transaction Code".

Table B has two columns: "Transaction Code" and "Transaction Description".  

The two tables are linked through columns "Transaction Code".

Table A has a row which in it we have "Transaction Code= XYZ"

Table B also has a row which in it "Transaction Code = XYZ" and "Transaction Description = ABC"

 

I then create a visual (table) with "A.Transaction Code" and "B.Transaction Description".

When I filter column "A.Transaction Code" to show value "XYZ" the visual returns blank row.

 

What could be the issue?

 

Other settings:

Cardinality: many to many

Cross filter direction: Both

Apply security filter in both direction: No

 

 

Thanks

Reza

 

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Ashish I have found the underlying issue and fixed it. It was incorrect data source. Many thanks for offering your help.

     

    Reza

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Ashish

     

    It does not allow me to choose anything other than Many to Many, otherwise the relationship cannot be active.

     

    Thanks

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User

      Hi,

      Could you share some data to work with and show the expected result.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi Ashish I have found the underlying issue and fixed it. It was incorrect data source. Many thanks for offering your help.

         

        Reza