topic Re: Convert strings into RGB in QlikView

Convert strings into RGB

Anonymous — Sat, 19 Nov 2016 20:40:15 GMT

Hi all,

Need some help on a tricky problem

Basically we have a bar chart which is dynamically when it comes to the dimension:

DimensionFilterTable:

LOAD * INLINE [

TableSelection, DimDisplayName

dim1, Country

dim2, Ciy

dim3, Seller

];

In the table we're working with a calculated dimension:

=$(=TableSelection)

So far it works perfect. But now I want to use different colors for the different dimension elements - the normal approach doing this in the loading script is not really useful because this DimensionFilterTable is flexible. My idea was now to somehow generate RGB depending on the string:

Element	Color
Exa1	red()
Exb2	green()
sdf	black()
Exa1	red()

Any idea? No script code should be used because it would mean to specify all the times the flexible dimensions and its elements with color codes. Something like this...but qlikish

Hash string into RGB color - Stack Overflow

Re: Convert strings into RGB

Gysbert_Wassenaar — Sun, 20 Nov 2016 11:58:59 GMT

Which color should be assigned to which dimension value? Is there a logic or do you simply want a random color assigned, any color will do as long as it is a color and each dimension value gets its own unique color?

Re: Convert strings into RGB

marcus_sommer — Sun, 20 Nov 2016 12:22:08 GMT

Maybe this is helpful: Colors in charts.

- Marcus

Re: Convert strings into RGB

swuehl — Sun, 20 Nov 2016 13:46:39 GMT

" the normal approach doing this in the loading script is not really useful because this DimensionFilterTable is flexible"

if this is your primary concern, you should be able to direct QV to the correct color code field (e,g. following Henric's blog post Marcus referenced) based on the dimension used with a similar approach you are using for the dimension:

DimensionFilterTable:

LOAD * INLINE [

TableSelection, DimDisplayName , DimColorCodeField

dim1, Country, CountryColor

dim2, Ciy, CityColor

dim3, Seller, SellerColor

];

=$(=Only(DimColorCodeField))

Re: Convert strings into RGB

Anonymous — Sun, 20 Nov 2016 15:24:26 GMT

Exactly - at the end we're displaying always the same points on a map but the different classifications of the elements should be seenable with a different color. The classification is in different dimensions...

Guess I found an easy solution:

hsl(

(

mod((ord(mid(Hash128(Dim1),3,1)) + (((ord(mid(Hash128(Dim1),2,1)) + (((ord(mid(trim(Hash128(Dim1)),len(trim(Hash128(Dim1)))-1,1)) + ((0 << 5) - 0)) << 5) - (ord(mid(trim(Hash128(Dim1)),len(trim(Hash128(Dim1)))-1,1)) + ((0 << 5) - 0)))) << 5) - (ord(mid(Hash128(Dim1),2,1)) + (((ord(mid(trim(Hash128(Dim1)),len(trim(Hash128(Dim1)))-1,1)) + ((0 << 5) - 0)) << 5) - (ord(mid(trim(Hash128(Dim1)),len(trim(Hash128(Dim1)))-1,1)) + ((0 << 5) - 0)))))),100)

) /100

mod(ord(mid(Hash128(Dim1),5,1)),10)/10,mod(ord(mid(Hash128(Dim1),8,1)),10)/10)

Where Dim1 is replacable by the $(TableSelection).

@Marcus / Stefan: This means I have:

a) always the same color for the different elements

b) I need to create a color mapping first with looping trough the elements

Re: Convert strings into RGB

Anonymous — Sun, 20 Nov 2016 15:27:20 GMT

Result:

Re: Convert strings into RGB

Gysbert_Wassenaar — Sun, 20 Nov 2016 17:26:12 GMT

Uhm, wow. I hope you didn't spend much time on putting that monster together.

Perhaps this will work too:

hsl(

FieldIndex('$(TableSelection)',[$(TableSelection)])/FieldValueCount('$(TableSelection)'),

0.5,

0.5

)

But imho a better idea is to load a table with colors like this one: List of Crayola crayon colors - Wikipedia‌. You could use the index value of the dimension to pick the color from the color table with the same index value.

Re: Convert strings into RGB

Anonymous — Sun, 20 Nov 2016 17:44:57 GMT

Ok wow - that's a lot smarter

Thanks, works like a charm.