topic Re: How to make stripes every 1 row in Pivot Tabel? in QlikView

How to make stripes every 1 row in Pivot Tabel?

Thu, 05 Apr 2012 09:06:41 GMT

How to make stripes every 1 row in Pivot Tabel?

May be someone know this code.

Thanks

How to make stripes every 1 row in Pivot Tabel?

Jason_Michaelides — Thu, 05 Apr 2012 09:27:36 GMT

I can't check this right now but isn't that an option in the style or presentation tab? It's there on straight tables for sure.

Hope this helps,

Jason

How to make stripes every 1 row in Pivot Tabel?

v_iyyappan — Thu, 05 Apr 2012 09:36:22 GMT

Hi,

Cau u attach sample image for your requirment?

Iyyappan

How to make stripes every 1 row in Pivot Tabel?

Jason_Michaelides — Thu, 05 Apr 2012 11:19:44 GMT

Looks like I was wrong and that option isn't available for pivot tables. However, expand the expression, select the background and in the definition box type:

=IF(Even(RowNo()),LightGray(),White())

Hope this helps,

Jason

How to make stripes every 1 row in Pivot Tabel?

Tue, 17 Apr 2012 08:28:32 GMT

This code can't work properly. May be someone can share another result code?

How to make stripes every 1 row in Pivot Tabel?

Tue, 17 Apr 2012 08:40:13 GMT

Hi Danny,

You'll need to use the AGGR() function is order to get the correct result in the pivot table. The field to be used in the formula is (usualy) the first column, depending on how you want the striping...

Try below code.

// colors rows - use calculation on 'Background'

// below formula gives at product_code level each row a different color: grey / white

IF(ODD(AGGR(NODISTINCT ROWNO(TOTAL),Product_Code)),WHITE(),

IF(EVEN(AGGR(NODISTINCT ROWNO(TOTAL),Product_Code)),LIGHTGRAY()))

Hope this works!

Regards, Anne

Re: How to make stripes every 1 row in Pivot Tabel?

jagan — Tue, 17 Apr 2012 09:50:25 GMT

Hi,

Try this expression as background expression

=IF(Even(RowNo(TOTAL)),LightGray(),White())

Check attached file for solution. I applied this expression for both dimensions and expression.

Regards,

Jagan.

Re: How to make stripes every 1 row in Pivot Tabel?

Mon, 30 Jul 2012 10:06:19 GMT

Thanks for this expression - is there an enhancement whereby it could be made to colour null/zero total values. Currently it is not colouring these.

Re: How to make stripes every 1 row in Pivot Tabel?

Mon, 18 Aug 2014 06:30:23 GMT

Hi Jagan,

Thanks for sharing the above file. I have a concern here:

What if I drag the month_name as columns. Currently they are acting as rows for each year.

Then how will i be able to have alternate color patterns?

Re: How to make stripes every 1 row in Pivot Tabel?

jagan — Mon, 18 Aug 2014 06:48:18 GMT

Hi,

I didn't get you, can you come up with an example and expected output.

Regards,

Jagan.

Re: How to make stripes every 1 row in Pivot Tabel?

Wed, 13 May 2015 15:07:50 GMT

Hi,

Not sure if this is what you are after, but hope that it helps.

All done in Chart Properties...

Regards,

Re: How to make stripes every 1 row in Pivot Tabel?

Rich-HHE — Thu, 19 May 2016 17:41:56 GMT

He's referring to a pivot table. You have a straight table.