topic Re: Coloring alternate rows in a straight table in App Development

Coloring alternate rows in a straight table

FranciscoQ — Wed, 02 Feb 2022 20:39:52 GMT

Hi, I would like to know if there is a way to have a background with an alternate row shading.

I know you can type an expression like:

if(Even(RowNo(TOTAL)), rgb(219,219,219), rgb(255,255,255))

But you have to type it in every measure or field in order to have the whole table with an alternate shading,

I'm wondering if there is a way to implement that style to the whole table, so every time I add a new measure or dimension, automatically has an alternate shading, or so I don't have to write the expression in all the columns.

Re: Coloring alternate rows in a straight table

Lisa_P — Wed, 02 Feb 2022 21:50:27 GMT

Try using the P&L Pivot in the Visualization bundle, it will do this automatically

Re: Coloring alternate rows in a straight table

anat — Thu, 03 Feb 2022 03:46:01 GMT

https://community.qlik.com/t5/New-to-Qlik-Sense/Alternate-row-color-in-table-chart-in-Qlik-sense/td-p/1373473

=if(Even(RowNO(total))=0,LightBlue(),Green())

Re: Coloring alternate rows in a straight table

chris_djih — Thu, 03 Feb 2022 07:55:26 GMT

If you don't want to do this in every table manually, you should consider doing it by changing your theme.css.

This are the needed lines:

/* -- stragiht tables: odd row white-- */ .qv-object-table .qv-inner-object .qv-object-content-container .qv-grid-object-scroll-area table tr:nth-child(even) { background: #ffffff } /* -- stragiht tables: odd row gray -- */ .qv-object-table .qv-inner-object .qv-object-content-container .qv-grid-object-scroll-area table tr:nth-child(odd) { background: #EAEAEA } /* -- pivot tables: odd row gray -- */ .qv-object-pt .qv-inner-object .qv-object-content-container .qv-grid-object-scroll-area pt tr:nth-child(odd) { background: #EAEAEA }

just add them to your theme.css