Coloring the same table cells the same color

[SaturnV]

Is there a way to color the same values in a column the same color?
I have about 1000 different values and the same value occurs more than once in this table.

So I will not use an if here like "if (Status='Service', red())". Because I have many different, dynamic values. It should just color same values the same color to group it and make a better overview.

Can't find any solution...

Best regards

Julian

[rwunderlich · Accepted solution]

Are the values dimensions -- ie fixed values -- or measure calculated values?

-Rob

[SaturnV]

Hey Rob,

 the values are dimensions.

Best,

Julian

[rwunderlich · Accepted solution]

I'll use the field CategoryName instated of Status to demonstrate.

If you want to use a single color for all duplicate values:

if(Count(total<CategoryName> CategoryName) > 1, blue())

If you want each duplicate CategoryName to use a different color. 

if(Count(total<CategoryName> CategoryName) > 1, Color(FieldIndex('CategoryName', CategoryName)))

The color() function will only return 20 values and will calculate values > 20 as Mod(n, 20).  So you will get some repeating colors with 1000 values  unless you come up with some other coloring scheme. But this should get you started. 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com