topic Re: Color the Row selected in QlikView

Color the Row selected

Anonymous — Wed, 27 Apr 2016 21:46:52 GMT

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!

Re: Color the Row selected

sunny_talwar — Wed, 27 Apr 2016 21:56:31 GMT

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))))

Re: Color the Row selected

Anonymous — Wed, 27 Apr 2016 22:16:11 GMT

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

Re: Color the Row selected

sunny_talwar — Wed, 27 Apr 2016 22:44:57 GMT

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

Re: Color the Row selected

Anonymous — Wed, 27 Apr 2016 22:57:56 GMT

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

Re: Color the Row selected

swuehl — Wed, 27 Apr 2016 23:21:51 GMT

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.

Re: Color the Row selected

Anonymous — Wed, 27 Apr 2016 23:31:04 GMT

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 )

Re: Color the Row selected

Anonymous — Thu, 28 Apr 2016 05:31:15 GMT

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 .. ?

Re: Color the Row selected

swuehl — Thu, 28 Apr 2016 06:32:03 GMT

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.