ARGB in the script

Fri, 01 Apr 2016 09:59:46 GMT

Hello,

I have an "agency" field and I try to set a specific color per branch. I would like to optimize my graphics and thus make this method through the script (and not having to specify each time in my expression, in background color more precisely, the formula to usa).

To know that my QlikView QVD project generates files (one file per table QVD).

Besides that, under Excel, I have an excel file named "Parameters" with two tabs, one calling itself "metadata" (I renamed the tables and fields) that looks like this:

TABLE.IN TABLE.OUT FIELD.IN FIELD.OUT

................ ............... ............... .................

And the other tab naming "color" which is as follows:

NAME A R G B

Agency1 255 255 153 51

Agency2 255 0 153 0

Agency3 255 51 0 153

Agency4 255 255 255 153

I wrote this in the script but it does not work ..... :

In the script, in the COLOR tab:
color_map:
Mapping
LOAD NAME, argB (A, R, G, B) as nameColor
FROM [xxxxxxxxParameters.xlsx] (OOXML, embedded labels table is COLOR)
;

In the script, in the QVD tab:
ApplyMap ( 'COLOR' NAME) have nameColor

Can anyone help me solve my problem?

Regards,

Prees

Re: ARGB in the script

Gysbert_Wassenaar — Fri, 01 Apr 2016 11:20:40 GMT

ApplyMap ( 'COLOR' NAME) have nameColor

This is not a correct syntax to use applymap

Applymap() needs at least two arguments:

the name of the mapping table, in your case color_map
an expression that returns the value that should be looked up in the mapping table.

You need something like Applymap('color_map', MyFieldNameHere) as NewFieldNameHere

Re: ARGB in the script

HirisH_V7 — Sat, 02 Apr 2016 07:38:27 GMT

Hi,

check this,

Color Logic – loading multiple Color schemes

topic Re: ARGB in the script in QlikView

ARGB in the script

Re: ARGB in the script

Re: ARGB in the script