topic Re: Stripes on pivot table in QlikView

Stripes on pivot table

maxime66 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 30 Jan 2018 12:47:29 GMT

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 — Tue, 30 Jan 2018 12:53:32 GMT

This to retain the values when exporting

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

sunny_talwar — Tue, 30 Jan 2018 12:56:34 GMT

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

maxime66 — Tue, 30 Jan 2018 13:56:36 GMT

Good idea !

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

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

maxime66 — Tue, 30 Jan 2018 14:03:52 GMT

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 — Tue, 30 Jan 2018 16:03:16 GMT

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