idea Re: Alternate row shading for tables in Suggest an Idea

Alternate row shading for tables

ieydis — Wed, 25 Nov 2020 15:02:35 GMT

Suggesting an option for tables have a feature to alternate row shading. This would make the data easier to read and process, especially for numerical values having many rows.

Re: Alternate row shading for tables

adaniels22 — Tue, 31 Mar 2020 16:29:19 GMT

Agreed

Re: Alternate row shading for tables

mmarchese — Tue, 14 Apr 2020 20:54:30 GMT

+1 This is a good idea. I would think Qlik could just update the included themes ever so slightly to implement it, but what do I know.

In the meantime, you can use the theme I made, which is just the regular "Classic" theme but with the following CSS to get alternating white and green backgrounds. I don't see a button to attach it, so here are the contents of the 3 files that you need to zip up and import.

theme-sense-classic-with-green-bars.qext:

{ "name": "Sense Classic with Green Bars", "description": "This theme is the same as the Sense Classic theme but with alternating row colors in straight tables.", "type": "theme", "version": "1.0.0", "author": "Mike Marchese" }

theme.css

.qv-object-table .qv-inner-object .qv-object-content-container .qv-grid-object-scroll-area table tr:nth-child(even) { background: rgb(212, 255, 215) } .qv-object-table .qv-inner-object .qv-object-content-container .qv-grid-object-scroll-area table tr:nth-child(odd) { background: #ffffff }

theme.json

{ "_inherit": true, "customStyles": [ { "cssRef": "theme.css", "classRef": "my-theme" } ] }

Re: Alternate row shading for tables - Status changed to: Open - Collecting Feedback

Patric_Nordstrom — Tue, 21 Apr 2020 12:53:37 GMT

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

It is possible today using a formula, set the bg color to =if(mod(rowno(total),2)=0,'lightgray')

For an example see sheet "Pajama striping" https://community.qlik.com/t5/Qlik-Sense-Documents-Videos/Top-10-Viz-tricks-Qonnections-2019/ta-p/1580174

Thanks,

Patric

Re: Alternate row shading for tables

mmarchese — Tue, 21 Apr 2020 14:14:33 GMT

@Patric_Nordstrom Thanks for the suggestion. Unfortunately, when using that approach, you have to set the bg color to that formula for every column, in every table, on every sheet, in every app. That's a whole lot of busywork, so I don't recommend it.

Re: Alternate row shading for tables

Sajid_Mahmood — Thu, 23 Apr 2020 11:57:15 GMT

This is a must feature

Re: Alternate row shading for tables

ieydis — Tue, 22 Sep 2020 20:41:22 GMT

@mmarchese Thanks for the suggestion on the theme. I will try this out!

Re: Alternate row shading for tables

SGV — Fri, 02 Oct 2020 18:24:55 GMT

@Patric_Nordstrom Unfortunately, with your formula approach, sorting on Y- Value will be affected.

See here:

Re: Alternate row shading for tables

Patric_Nordstrom — Thu, 15 Oct 2020 19:24:37 GMT

@SGV true, a possible workaround is to use/create another numeric field with order to use instead of rowno().

Thanks,

Patric

Re: Alternate row shading for tables

Patric_Nordstrom — Mon, 16 Nov 2020 12:23:39 GMT

@SGV , @mmarchese or to use rank() instead of rowno().

Re: Alternate row shading for tables

charshea — Tue, 18 May 2021 12:41:01 GMT

@Patric_Nordstrom Hello! We do use the mod rowno technique for shading. Usually it works fine; however, we run into problems (where the shading is NOT every other row) when we are excluding zeros from a table. (In Data Handling, we have unchecked "Include zero values".) Do you have a way to address this issue? Your help would be greatly appreciated!

Thanks,

Charlotte Shea

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Mon, 18 Sep 2023 16:55:37 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Alternate row shading for tables - Status changed to: Closed - Archived

Ideation — Mon, 18 Sep 2023 16:55:39 GMT