topic Re: Different color for odd and even lines in a table in App Development

Different color for odd and even lines in a table

madnanansari — Thu, 13 Apr 2017 10:50:51 GMT

I have a sheet with a table in Qlik Sense having 20 columns having 4 dimensions and 16 kpi.

When the user looks at it; he is lost which line he is looking at.

We have to highlight OR change color of the full line OR set the background color for alternate (odd or even) lines so that user feels it handy to read the report.

This is same like EXCEL where we highlight the odd lines to look different from the upper line.

Re: Different color for odd and even lines in a table

shraddha_g — Thu, 13 Apr 2017 11:02:58 GMT

In Background color,

for alternate line coloring you can use:

If(Mod(Rowno(Total),2),Red(),green())

Re: Different color for odd and even lines in a table

kkkumar82 — Thu, 13 Apr 2017 11:12:38 GMT

Hi tried something like this, please check the image

is this something your are looking for

Re: Different color for odd and even lines in a table

kkkumar82 — Thu, 13 Apr 2017 11:13:46 GMT

I have used condition similar to Shraddha

Re: Different color for odd and even lines in a table

madnanansari — Thu, 13 Apr 2017 12:46:13 GMT

yes

Re: Different color for odd and even lines in a table

Anonymous — Thu, 22 Mar 2018 09:43:19 GMT

Hello,

this is not a good solution. I've tried it on my own.

Coloring the rows works fine, but after I added the formel "If(Mod(Rowno(Total),2),Red(),green())" i cant't sort my columns. If i delete the formel, sorting the columns works fine. Is there a solution for this problem, which works also with the possibility to sort the columns?

Best regards,

Patrick