Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Dynamic colour format striped table

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Dynamic colour format striped table

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).

qv3.png

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

5 Replies
MVP
MVP

Re: Dynamic colour format striped table

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).

qv3.png

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

Not applicable

Re: Dynamic colour format striped table

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!

Not applicable

Re: Dynamic colour format striped table

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

MVP
MVP

Re: Dynamic colour format striped table

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

Not applicable

Re: Dynamic colour format striped table

Here it is:

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

The expression cant be sorted anymore.

It's beacause of the RowNo

Regards,

Community Browser