Forum Discussion

ArielK's avatar
ArielK
Frequent Visitor
2 years ago
Solved

Relationship - show lines with no values

HI All

 

I am trying to achieve something that in my head seems easy, but I can't find solution.

 

I have 2 tables:

- Stock - with sales indexes like this:

 

indexparameter
ax
by
cx
dz

 

- second with sales, like this:

 

indexdatesales
a1.2024100
a2.202450
a3.202440
c1.202410
c2.202415
c3.202413

 

There is one way relationship between those tables (stock filters sales). 

 

I made matrix visual where I want to show all indexes from first table and sales if there was any.

I don’t want sales table to filter index table. I expect to achieve, something like this:

 

  1.20242.20243.2024
ax1005040
by   
cx101513
dz   

 

It works ok for the indexes that have sales but indexes that have no sales are filtered, so i end up with such visual:

 

  1.20242.20243.2024
ax1005040
cx101513

 

Is there any way to avoid this filtering? is there somewhere option "show lines with no values" etc.?

I tried to change relationship type, run through settings but still no success.

I would really appreciate your support.

 

Thank you!

 

  • ArielK,

     

    Click the down arrow for the field in the field well, and select "Show items with no data".

     

     

2 Replies

  • ArielK,

     

    Click the down arrow for the field in the field well, and select "Show items with no data".

     

     

  • ArielK's avatar
    ArielK
    Frequent Visitor

    Thanks a lot! I was pretty sure that I saw option like this somewhere, but I spent 2 hours digging through settings and finally lost hope. 😉