Documents for QlikView related information.
Here's a basic script which loads an excel workbook sheet containing colours into QlikView.
Once loaded the script loops through the table and creates variables which can be used in your design template.
I will be uploading a video tutorial to my blog shortly.
we use a similar script:
Colour_Table:LOAD VariableName, RGBValue, ColourNameFROM[\\..\..\Colour_Scheme.xlsx](ooxml, embedded labels, table is Colours);
FOR i=1 to $(NumRows) let vVariableName = FieldValue('VariableName',$(i)); let vVariableRGB = FieldValue('RGBValue',$(i)); let $(vVariableName) = '=$(vVariableRGB)'; NEXT
Comment Tables Colour_Table With 'This is the new way';
Great minds James!!
I have done something similar and I am using a function for each color in a given chart's palette. I find that when I reference these colors using the color(n) function, the "fixed" option for the color is used instead of the calculated color. Have you experienced this as well? I am struggling to find a solution.
I'm not sure if I fully understand your issue. I have instances where using the $(=RGB(*,*,*)) a variable doesn't work. Usually within conditional statements and I have to use the individual colour values
Could you provide a little more information and perhaps a link to an example?
Here is a link to the blog video:
we have sth like that as well, only we don't use an Excel file, but just a qvd file with the SET commands. It's very helpful to make it all appear somewhat uniform and not have it blaring in all kinds of colours.