I don't understand the "Show if" expression to work

[Erik_van_Egmond]

Hi all,

I have a problem with the “Show If” expression in a reference view.

I have two tables (Type 1 and Type 2) an a join table.
Type 1 contains people and Type 2 their transportation mode.
In the join table these in the third table.
For both types I have a simple overview and detail view. The detail view shows the related data from the join table.
The goal is to show the name of the current type first. So when looking at Alice I want to have Alice as title and Auto as subtitle. When looking at Auto I want the reverse. As you can see below this is not the case. Both views have the “Join Type 1” view.
“Join Type 1” is a copy of the default inline view but with card mode and some configuration. There is also “Join Type 2” which shows the Type 2 name first as described earlier.

I expected the “Show if” expression would allow me to configure when the views are shown. However I don’t get it to work. I have set “Join Type 1” to “false” but it still shows in both cases. Could it be that I’m using the “Show If” field wrong?

When I know how I should use this “Show if” field I’d like to use the following formula to get the desired behaviour:
CONTEXT(“View”) = “Type 1_Detail”

thanks in advance,

Erik

[Kirk_Masden]

Perhaps “Show if” is not what you need to use in this case:

Erik_van_Egmond:

So when looking at Alice I want to have Alice as title and Auto as subtitle. When looking at Auto I want the reverse. As you can see below this is not the case. Both views have the “Join Type 1” view.

For titles, I think you want to use the “Header columns” setting in the view editor:

[Erik_van_Egmond]

Thank you for your response.

My goal is that depending on point of view you have a different inline view.
So when looking at the detail page of Alice there is an inline view of the Join table.
When looking at the detail page of Auto there is also an inline view of the Join table.
Currently this is the same view in both cases, but I want to have a different view in these different cases. In this example app I want the title and subtitle to be reversed depending on the view.

Your screenshot seems to be of the detail page of the join table.
I expected the “Show If” to be helpfull here, but apparently not. Could you explain how or when this field should be used instead?

[Marc_Dillon · Accepted solution]

You need a separate Slice for each view type. Setup the UX->View per each Slice. Create a new Virtual Column per Slice, in which you’ll enter a REF_ROWS() expression that points to the Slice instead of the base table. Your Show_If expressions should go into the Virtual Columns.

[Erik_van_Egmond]

Thank you, using slices I can do what I want.