Colours

[ecolomer]

Hi,

I've this script:

Set HidePrefix='%';

Base:

LOAD * INLINE [

    %Color Scheme, Color_A, Color_B, Flag

    Blue, "RGB(52, 152, 219)", "RGB(41, 128, 185)", 1

    Bright Green, "RGB(46, 204, 113)", "RGB(39, 174, 96)", 1

    Orange, "RGB(230, 126, 34)", "RGB(211, 84, 0)", 1

    Red, "RGB(231, 76, 60)", "RGB(192, 57, 43)", 1

    Turquoise, "RGB(26, 188, 156)", "RGB(22, 160, 133)", 1

    Yellow, "RGB(241, 196, 15)", "RGB(243, 156, 18)", 1

    Purple, "RGB(155, 89, 182)", "RGB(142, 68, 173)", 1

    Light Pink, "RGB(224,130,131)","RGB(214,69,65)", 1

    Light Orange, "RGB(242,120,75)","RGB(249,105,14)", 1

    Navy Blue, "RGB(103,128,159)","RGB(52,73,94)",1

    Light Blue, "RGB(134,226,213)","RGB(101,198,187)",1

    Light Purple, "RGB(190,144,212)","RGB(142,68,173)",1

];

And I would like a table of values ​​Color_A and Color_B, addition to make the background color representing value

[MK_QSL]

Can you give bit more idea about what you want please?

i.e. how you want to use them?

[danieloberbilli]

this should work:

=$(=Only(Color_A))

[ecolomer]

Is only a test

In this moment works only if I select a color, but not in a box list or

[MK_QSL]

In case of different Flag defined for each color...

=$(=Only({<Flag = {2}>}Color_A))

[danieloberbilli]

Try something like this:

[MarcoWedel · Accepted solution]

Hi,

when I read your post, I thought you had something like color calculations in mind.

Maybe it's not what you're looking for, but nevertheless helps:

SET HidePrefix='%';
Base:
LOAD * INLINE [
    %Color Scheme, Color_A, Color_B, Flag
    Blue, "RGB(52, 152, 219)", "RGB(41, 128, 185)", 1
    Bright Green, "RGB(46, 204, 113)", "RGB(39, 174, 96)", 1
    Orange, "RGB(230, 126, 34)", "RGB(211, 84, 0)", 1
    Red, "RGB(231, 76, 60)", "RGB(192, 57, 43)", 1
    Turquoise, "RGB(26, 188, 156)", "RGB(22, 160, 133)", 1
    Yellow, "RGB(241, 196, 15)", "RGB(243, 156, 18)", 1
    Purple, "RGB(155, 89, 182)", "RGB(142, 68, 173)", 1
    Light Pink, "RGB(224,130,131)","RGB(214,69,65)", 1
    Light Orange, "RGB(242,120,75)","RGB(249,105,14)", 1
    Navy Blue, "RGB(103,128,159)","RGB(52,73,94)",1
    Light Blue, "RGB(134,226,213)","RGB(101,198,187)",1
    Light Purple, "RGB(190,144,212)","RGB(142,68,173)",1
];

tabTemp:
CrossTable (ColorName, RGB)
LOAD [%Color Scheme], Color_A, Color_B
Resident Base;

tabColorComponents:
LOAD [%Color Scheme],
    ColorName,
    SubField(TextBetween(RGB,'(',')'),',') as ColorValue,
    Dual(Pick(AutoNumber(RowNo(),AutoNumberHash128([%Color Scheme],ColorName,)),'R','G','B'),
    AutoNumber(RowNo(),AutoNumberHash128([%Color Scheme],ColorName,))) as ColorComponent
Resident tabTemp;

DROP Table tabTemp;

tabColorCalc:
LOAD [%Color Scheme],
    'RGB('&Concat(Color_Sum,' ,',ColorComponent)&')' as Color_Sum,
    'RGB('&Concat(Color_Min,' ,',ColorComponent)&')' as Color_Min,
    'RGB('&Concat(Color_Max,' ,',ColorComponent)&')' as Color_Max,
    'RGB('&Concat(Color_Avg,' ,',ColorComponent)&')' as Color_Avg
Group By [%Color Scheme];
LOAD [%Color Scheme],
    ColorComponent,
    Sum(ColorValue) as Color_Sum,
    Min(ColorValue) as Color_Min,
    Max(ColorValue) as Color_Max,
    Round(Avg(ColorValue)) as Color_Avg
Resident tabColorComponents
Group By [%Color Scheme], ColorComponent;

regards

Marco

[ecolomer]

Brilliant

Yes you are read my mind.....!!!

TX

[MarcoWedel]

maybe like this also?:

hope this helps

regards

Marco

[MarcoWedel]

you're welcome

regards

Marco