Forum Discussion
Relationships
Try playing around a bit with the Cross Filter Direction on each relationship, setting them to Single, as opposed to Both, in this situation might work. That might allow you to define the relationships without making any of them inactive. Of course once you get them defined be sure to check the interactivity on the visuals you have to ensure they are reacting as necessary for your usage scenario.
Advocate IVTjena Jeroenvb1
Problem is occuring because filter is getting passed to other tables.
Can you do following ?
Create another Datum table, a copy may be(call it Klanten Date), and create realtionship of it with Klanten. Kind of breaking the loop.
Hope it helps you !
Also provide some sample data here so we can mimic your problem.
BR,
/Achin
Hi Tjena,
What exactly do you mean with "filter is getting passed to other tables"? I tried removing all filters on the queries but it did not help any.
I also duplicated the datum table and created a relationship between cust. ledger entries and klantendate and between article budget entries and datum. This indeed breaks the loop but i the problem remains the same. If you want to see see the sales and budget per month, you still need to have some date link between these two. Do you have any other ideas.
I have some sample data but apparently i cannot upload this into this post. Maybe i can send it to you?
Kind regards