topic Re: Stripes every 1 row pivot table qlikview in QlikView

Stripes every 1 row pivot table qlikview

inescastelhano — Wed, 06 Apr 2016 11:19:35 GMT

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

Re: Stripes every 1 row pivot table qlikview

Chanty4u — Wed, 06 Apr 2016 11:24:53 GMT

ttry this

lik below

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

Re: Stripes every 1 row pivot table qlikview

amit_saini — Wed, 06 Apr 2016 11:35:11 GMT

Hi,

Try something below:

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

Thanks,

Re: Stripes every 1 row pivot table qlikview

amit_saini — Wed, 06 Apr 2016 11:38:43 GMT

Also check:

Re: Color problem when values are null

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

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

Thanks,

Re: Stripes every 1 row pivot table qlikview

HirisH_V7 — Wed, 06 Apr 2016 12:07:45 GMT

Hi,

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

HTH,

Hirish

Re: Stripes every 1 row pivot table qlikview

inescastelhano — Wed, 06 Apr 2016 12:57:16 GMT

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

Re: Stripes every 1 row pivot table qlikview

inescastelhano — Wed, 06 Apr 2016 12:58:07 GMT

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

Thanks,

Inês

Re: Stripes every 1 row pivot table qlikview

inescastelhano — Wed, 06 Apr 2016 12:58:55 GMT

Doesn't work

Thanks for your reply.

Inês

Re: Stripes every 1 row pivot table qlikview

amit_saini — Wed, 06 Apr 2016 13:00:58 GMT

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

Thanks

Re: Stripes every 1 row pivot table qlikview

avinashelite — Wed, 06 Apr 2016 13:14:41 GMT

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

Re: Stripes every 1 row pivot table qlikview

HirisH_V7 — Wed, 06 Apr 2016 13:20:37 GMT

Hi,

Check this ,In your Dimensions-> Background Color

Expressions ->Background Color

=if(Mod(RowNo(),2)=0,LightGray(),white())

HTH,

Hirish

Re: Stripes every 1 row pivot table qlikview

inescastelhano — Wed, 06 Apr 2016 13:27:41 GMT

Also does not work .

Re: Stripes every 1 row pivot table qlikview

HirisH_V7 — Wed, 06 Apr 2016 13:32:05 GMT

can u please share your screen short or app if possible.