topic Re: Default for stripes every 10 rows in QlikView

Default for stripes every 10 rows

tinkerz1 — Mon, 04 Jan 2016 08:40:39 GMT

Hi,

In the chart properties under style>Stripes every 10 rows.

If I change the rows to greater than 10, QV defaults back to 10 for straight tables.

How can I keep the stripes to my number?

Re: Default for stripes every 10 rows

HirisH_V7 — Mon, 04 Jan 2016 09:22:49 GMT

Hi Check this,

Expression,back Ground Color,

=if(mod(RowNo(total),10)=0,lightgreen(),lightblue())

HTH,

PFA,

Hirish

Re: Default for stripes every 10 rows

Chanty4u — Mon, 04 Jan 2016 10:58:33 GMT

nice..hirish

Re: Default for stripes every 10 rows

tinkerz1 — Mon, 04 Jan 2016 11:15:19 GMT

Hi,

That looks great but its in a pivot table not a chart.

Re: Default for stripes every 10 rows

HirisH_V7 — Mon, 04 Jan 2016 11:45:50 GMT

check this,

Same Expression but ,Change type of chart.

PFA,

HTH,

Hirish

Re: Default for stripes every 10 rows

tinkerz1 — Tue, 05 Jan 2016 09:15:21 GMT

Hi, I was after stripping every other 16 rows, so blocks of alternating stripes, the first 16 begin white then the next 16 grey, then the next 16 white etc.

Thanks

Re: Default for stripes every 10 rows

tresB — Tue, 05 Jan 2016 09:40:09 GMT

Try background color expression, like :

=Color(Floor(RowNo()/16)+1)

Re: Default for stripes every 10 rows

HirisH_V7 — Tue, 05 Jan 2016 09:55:35 GMT

Hi Tresesco,

It works,If we want only two colors means !

-Hirish

Re: Default for stripes every 10 rows

tresB — Tue, 05 Jan 2016 10:00:11 GMT

Then, something like:

Color(Mod(Floor(RowNo()/16),2)+1)

Re: Default for stripes every 10 rows

HirisH_V7 — Tue, 05 Jan 2016 10:15:01 GMT

Thank you very much tresesco ...Its working

-Hirish