Color the Row selected

[Anonymous]

Hi

Attached is my application , I am trying to color the row selected , it works only the first time I select a Category value , when I select 2 value from the table it does not color .. it colors the row when I select the same value second time .. I know it kind of weird .. can some one please take a look at

sunindia‌ .. As you have an idea on the expressions I have , tagging you .. really appreciate if you take a look at it

Thank you!

[sunny_talwar]

Try this concept for all your background colors

=if(Dimensionality() =0 , rgb(245,245,245),

if(SubStringCount(GetFieldSelections(Category, '|'), Category) = 1, $(cBackGroundBlue),

if(Column(2) <= Column(4), $(cGreen))))

[Anonymous]

It is still the same .. it does color every time I select a value .. in the attached application too ...

[sunny_talwar]

I guess I don't know what you are looking for. Can you elaborate a little

[Anonymous]

I just want the selected row to be highlighted to Blue ... which does happen consistently .. I mean when I click on a cell it does color for the first time , but when I click on next value it does not color , but if I select the same value again it colors.

I wanted the row to be colored in blue when I click on a cell value in the table .. hope it makes some sense

[swuehl · Accepted solution]

If you look at the current selections box, you will notice that the issue is caused by your Category selection being removed when doing another selection in the chart.

Not quite sure what is causing this, it seems like this is caused by the use of the calculated dimensions.

I've replaced the calculated dimension with a field, seems to work now.

[Anonymous]

ok .. so as we have the values now in Category2 column separately I don't have to mention the Category values in my expressions right ?

=only({<CLNDR_DT={'$(=vPreviousDate)'},Category2 ={'P0 Escapes','P1 Escapes','P2 Escapes','P3 Escapes'},Date,Category2=>} Data )

[Anonymous]

Can I know how you were able to reload my file? and also if I reload the same file on my machine it says table not found .. ?

[swuehl]

To be able to reload, I used an ADD LOAD prefix and a partial LOAD. You don't need to do this in your real environment being able to do to full reload with all source files.

In your case, I think you just need to create the new field in the same table as Category.