Stripes on pivot table

[maxime66]

Hi qlikers !

i would like to color one row each two row.

The .qvw attached worked on Qlikview V11 but seems not working anymore on V12.

Null values don't color and also dimensions don't color well.

any ideas how to do it ?

thanks.

[vinieme12]

Use below expression

=DUal(sum([nb product]),0.00001)

the reason is Rowno() is not calculated for Null() values, so add  default value like 0.00001

[vinieme12]

OR

This to retain the values when exporting

=DUal(sum([nb product]),if(sum([nb product])>0,sum([nb product]),'x'))

[sunny_talwar · Accepted solution]

Not sure if this is okay, but unchecking 'Suppress Zero-Values' might help.... only issue is that you will see 0 instead of -

[maxime66]

Good idea !

I add transparency of values if =0, works perfect !

=if(sum([nb product])=0,argb (0,0,0,0))

[maxime66]

Just a quick note speaking of pivot design,

i nerver found how to remove the empty column between dimension and expression.

When  there is 2 expressions or more,  this column disappear ...

it's quite an annoying issue.

[sunny_talwar]

Yes it is indeed very annoying and I wish there was a way to get rid of it or assign color to it...