Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
Creator II
Creator II

Default for stripes every 10 rows

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?

9 Replies
HirisH_V7
Master
Master

Hi Check this,

Stripes.PNG

Expression,back Ground Color,

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

HTH,

PFA,

Hirish

HirisH
Chanty4u
MVP
MVP

nice..hirish

tinkerz1
Creator II
Creator II
Author

Hi,

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

HirisH_V7
Master
Master

Hi

check this,

Stripes2.PNG

Same Expression but ,Change type of chart.

PFA,

HTH,

Hirish

HirisH
tinkerz1
Creator II
Creator II
Author

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

tresesco
MVP
MVP

Try background color expression, like :

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

HirisH_V7
Master
Master

Hi Tresesco,

It works,If we want only two colors means !

-Hirish

HirisH
tresesco
MVP
MVP

Then, something like:

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

HirisH_V7
Master
Master

Thank you very much tresesco  ...Its working

stripesss.PNG

-Hirish

HirisH