Cell formating lost with set analysis

[skovsgaard]

Hi

I have been struggling the last couple of days with formating a straight table, and keeping the table structure and format when making selections within the table.

Overall issue: Set analysis ensures that the table structure is intact when selecting a category, but formating of blank rows and totals disappear.

Details: (See layout in the attached qvw file)

In the table "Straight table with Set analysis" the two red columns are to be deleted or hidden at a later point, and I want to have the format as shown in the column Category and Value. With set analysis I have ensured that I can click on i.e A1, and the same rows still appear, but issue is that the blue background of "A total" disappear.

I understand the reason that this happens, as the format of the category totals is based on the value in field Type, and when you click on a category the underlying data now only have this category selected, but set analysis gives another view, and therefore the Totals can no longer relate to the type field. This is evident for the table box showing the underlying selected data.

Anyone knows a solution or work around to this?

Regards

Soren

[Nicole-Smith]

Make sure to check "Detached".

[sebastiandperei · Accepted solution]

Hi skovsgaard,

You are right, when you make selections, type will only get the available value. You could fix it with using Only function in Dimention Background expression with {1}, like this:

=if(Only({1}Type) = 'Total',rgb(197,217,241))

[skovsgaard]

Thanks Sebastian. That works. Not sure I understand yet how it works, but I will probably figure that out at a later stage, but most important that it works.

Regards

Soren

[skovsgaard]

Hi Nicole

That would be an easy solution, but unfortunately, for some reason, detached gets deflagged when you reload data, and is therefore of no use when working with data that needs to be published.

But thanks for taking the time to reply.

Regards

Soren

[sebastiandperei]

Detach is very useful, but is temporarly solution. The graph is freezed in the state.

The function Only gives you a single value of the field Type. With {1}, you make independence of the selections.