topic Re: How to high light those summary row ? in QlikView

How to high light those summary row ?

Tue, 03 Jun 2014 14:21:25 GMT

Hi All

I have a table , the table have few summary row , i like to high light those row with light red black ground color. May i know how to go about it ?

Tue, 03 Jun 2014 14:28:20 GMT

Hi All

Enclosed my QV doc

Paul

Tue, 03 Jun 2014 14:58:34 GMT

Hi Paul

you can use Background color like

=if( Seq = 7 or Seq = 14 or Seq = 15 or Seq = 46, lightred())

best regards

chris

Tue, 03 Jun 2014 15:10:30 GMT

Settings > user preferences > Design - check the 'Always show design menu items'

on chart : right click on the cell which you wanted to format and select 'Custom Format Cell' and change colors.

Tue, 03 Jun 2014 22:47:19 GMT

Hi Christian

Thank you vey much for your reply.

I just notice that , now my table , at the expression , at text format , it have below expression :-

=if([Exec P&L Calculation]='c','<B>')

it is possible to modify the above expression and place it at black ground format , so that i can make your proposal script more simply ?

Paul