topic Total row in a straight table - Design problem in QlikView

Total row in a straight table - Design problem

eliran — Wed, 20 Oct 2010 14:53:59 GMT

Hi,

I'm designing my Straight Table , I colored the rows from the Visual Cues and the Total row from Custom Format Cell.

The rows have gray/white colors and the Total row is yellowish.

The problem occur in the gray fields, The yellow gets the gray into it as well, making the Total row to look pretty nasty.

Any solution to this problem?

Thanks.

Total row in a straight table - Design problem

boorgura — Wed, 20 Oct 2010 15:01:33 GMT

Try using the back ground color option in the expression options.

And there put in, if rowno() <>0, so that the coloring doesnot apply to total rows.

Let me know if that is what you are looking for.

Total row in a straight table - Design problem

eliran — Wed, 20 Oct 2010 15:12:42 GMT

Thanks for the help Rocky.

I get the logic of it, I just don't understand where to implement it.

I tried placing the suggested if inside the Properties - Expressions - Background Color - Definitions

and no luck..

Am I in the right place?

Total row in a straight table - Design problem

boorgura — Wed, 20 Oct 2010 15:43:04 GMT

yeah - you are in the right place. can you send out a sample attachment?

Total row in a straight table - Design problem

eliran — Wed, 20 Oct 2010 16:31:51 GMT

I attached an example file.

Thanks again, I appreciate it.

Total row in a straight table - Design problem

Wed, 20 Oct 2010 18:45:19 GMT

Hi,

is this what you want?

Regards

Total row in a straight table - Design problem

Wed, 20 Oct 2010 20:16:39 GMT

If all else fails, you could probably play around in the Custom Format Cell area.

Click in Qlikview and press ctrl+G. Then right click on the cells and then select "Custom Format Cell". I've used this several times to clean up my totals/titles row.

Total row in a straight table - Design problem

eliran — Wed, 20 Oct 2010 21:37:44 GMT

Execatamundo!

I see it's not being done in the visual cues of the expressions.

The yellow background is from the custom cell format as I can see, what about the gray/white color of the fields?

How did you set it?

Thanks!