topic Re: Dynamic colour format striped table in QlikView

Dynamic colour format striped table

Wed, 24 Jul 2013 09:56:36 GMT

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

Re: Dynamic colour format striped table

tresB — Wed, 24 Jul 2013 10:19:23 GMT

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.

Re: Dynamic colour format striped table

Wed, 24 Jul 2013 10:29:46 GMT

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!

Re: Dynamic colour format striped table

Wed, 24 Jul 2013 10:42:08 GMT

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

Re: Dynamic colour format striped table

tresB — Wed, 24 Jul 2013 10:47:02 GMT

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

Re: Dynamic colour format striped table

Wed, 24 Jul 2013 11:10:29 GMT

Here it is:

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

The expression cant be sorted anymore.

It's beacause of the RowNo

Regards,