Stripes every 1 row pivot table qlikview

[inescastelhano]

Hi all,

I have a pivot table and I would like to color the table with stripes.

I am using the following expression:

=if(Even(RowNo(TOTAL)), LightGray())

But it doesn't work for null values. Could somebody help me out?

Thanks in advance!

Cheers,

Inês

[Chanty4u]

ttry this

lik below

=IF(Even(RowNo()),RGB(245,245,245),White())

[amit_saini]

Hi,

Try something below:

=if( BalancePosition='Cash Flow from Operations',LightGray(150))

Thanks,

AS

[amit_saini]

Also check:

Re: Color problem when values are null

https://community.qlik.com/message/750433#750433

https://community.qlik.com/message/1009668#1009668

Thanks,

AS

[HirisH_V7]

Hi,

Check this in pivot table -> properties -> Style -> Stripes Every ->

HTH,

Hirish

[inescastelhano]

Hi, unfortunately I can't select that option (I don't know why, but I am not allowed to clik there).

Thanks for your reply.

Cheers,

Inês

[inescastelhano]

Sorry, I don't get it. What are BalancePosition and Cash Flow from operations supposed to be?

Thanks,

Inês

[inescastelhano]

Doesn't work

Thanks for your reply.

Inês

[amit_saini]

That was just for example, you need to change based on your Dimension.

Thanks

AS

[avinashelite]

Click on the current style > and select the color format that you need and then you will be able to select the number of strip rows