Dynamic colour format striped table

[#1]

Hello,

In a straight table, i have alternate lines which have to be striped in a different colour based on a condition in a variable.

How to assign a custom rgb() to the colour format, and is it possible?

Thank you in advance!

Regards

A

[tresesco · Accepted solution]

Directly with the striped table the option is not there (i don't know at least). But a work around comes in mind you can try that ( though it's a bit cumbersome).

you have to write this background expression for all dimension members and expresssions.

[#3]

Wonderful solution!! I had tried something similar but more complicated using mod(rank) .... but which changed the alternate stripes depending on the sort!

Thank you very much!

[#4]

But the problem with this solution that it kills the sort! .. any work around?

[tresesco]

It should not. Can you explain or share the sample app with issue.

[#6]

Here it is:

https://www.dropbox.com/s/02z0wafvx7t9ozf/COLOUR.qvw

The expression cant be sorted anymore.

It's beacause of the RowNo

Regards,