Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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!
But the problem with this solution that it kills the sort! .. any work around?
It should not. Can you explain or share the sample app with issue.
Here it is:
https://www.dropbox.com/s/02z0wafvx7t9ozf/COLOUR.qvw
The expression cant be sorted anymore.
It's beacause of the RowNo
Regards,