Forum Discussion
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
- Anonymous3 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
- Ashish_MathurSuper User
Hi,
Do you get the correct result when you use Many to One and Single.
- AnonymousNot applicable
Hi Ashish
It does not allow me to choose anything other than Many to Many, otherwise the relationship cannot be active.
Thanks
- Ashish_MathurSuper User
Hi,
Could you share some data to work with and show the expected result.
- AnonymousNot applicable
Hi Ashish I have found the underlying issue and fixed it. It was incorrect data source. Many thanks for offering your help.
Reza