topic Shading every other row in Pivot table in QlikView

Shading every other row in Pivot table

Mon, 11 Jan 2010 15:48:20 GMT

Hi all,

I'm trying to shade every other row in a pivot table simply based on being the odd or even row number. In other words rows 1,3,5,6,9,etc. would be a color and 2,4,6,8,10,etc. would be another color.

I've tried to write code on the background color of the field using rowno() and count() but no success.

Any suggestions would be extremely helpful.

Shading every other row in Pivot table

Mon, 11 Jan 2010 16:57:05 GMT

In a straight table it is a setting, but that doesn't work for a pivot table. However, you can set the background color on dimensions and expressions.

Dimension: click on the plus-sign in front of the dimension and double-click on the Background Color option.

Expression: click on the plus-sign in front of the dimension and click on the Background Color option. There is a Definition window on the right now.

Add the following expression to all the Background Color fields (dimensions and expressions):


=if(even(RowNo()),lightgray(),white())

If you don't like the color, you can use a lot of other standard colors (search 'color' in the help) or use RGB(230,230,230) for lighter grey for instance.

Shading every other row in Pivot table

Tue, 12 Jan 2010 10:21:39 GMT

Gud example is given by Mark. There is also a feature called 'ColorMix', see help. It is used to set colors for text, or background. More detail is available in manual on ColorMix.

Shading every other row in Pivot table

Tue, 12 Jan 2010 11:03:10 GMT

Cool ... thanks for the tip sunil18vns

Shading every other row in Pivot table

Tue, 12 Jan 2010 12:33:42 GMT

Thanks for your help.

Where can find the manual on ColorMix?

Shading every other row in Pivot table

Tue, 12 Jan 2010 12:36:12 GMT

It can be found in the Help. Just search for 'colormix'. I can post the text if you like

Shading every other row in Pivot table

Tue, 12 Jan 2010 12:37:04 GMT

Oops, double post ...

Shading every other row in Pivot table

Tue, 12 Jan 2010 13:00:35 GMT

In my case, it works when I have one dimension. But when I put multiple dimensions, the same formula does not work. Can anyone please check and let me know the reason.

Shading every other row in Pivot table

Tue, 12 Jan 2010 13:16:55 GMT

To be able to do that, you need an identifier for field product.

That way you can replace the 'even(RowNo())' part with something that identifies each product.

Have you tried the Color Mix Wizard?

Shading every other row in Pivot table

Tue, 12 Jan 2010 15:18:42 GMT

Hi Mark,

I searched for colormix in Help. I'm still not sure how to start/access the colormix wizard from the instructions below:

With the Colormix Wizard, opened from the File menu in the Edit Expression dialog, it is possible to create a colormix expression, i.e. an expression that calculates a dynamic color from a given measure.

Can you give me more specific instructions to access the colormix wizard?

Thanks

Ward

Shading every other row in Pivot table

Tue, 12 Jan 2010 15:41:01 GMT

Sure ...

Go to an expression in a chart/table/... and open the definition window. In the file menu you can find the Color Mix Wizard.

See image

Shading every other row in Pivot table

Tue, 12 Jan 2010 16:32:30 GMT

Thanks Mark.

I've been searching the forum for examples using the ColorMix wizard. Do you know of any?

Shading every other row in Pivot table

Tue, 12 Jan 2010 16:39:12 GMT

Nope, just learned about it today ...

Going to test it tomorrow though. I will post something about it afterwards.