topic Re: Color variables invalid after Publisher reload in QlikView

Color variables invalid after Publisher reload

kswindlehurst — Mon, 16 Jan 2017 19:05:57 GMT

Can anyone explain what is going on with this process:

The attached file has a chart and each column's background color is set to variables that I loaded via include script. I saved a copy of the qvw, erased the load script and changed it to a Binary load referring back to the original. On the server's client, I can reload it all day and the colors are fine. If I have publisher reload it, all the colors vanish, but the variable's all still have their RGB() assignments. The chart just won't process them. If I wrap the background color assignment in $( ), the color comes back. What happened?

Re: Color variables invalid after Publisher reload

enriquem — Tue, 17 Jan 2017 08:31:07 GMT

Hi!,

You need to include your script :

$(Include=..\your_file_path\your_file.qvs);

In your script you must have some variable like:

SET your_color_variable = rgb(0,0,0);

An finally, you must go to the chart properties, select the Colours tab and change the color click-in and in Calculated text box put this:

=$(your_color_variable)

(It's important select the Calculated radio button)

Regards.

Re: Color variables invalid after Publisher reload

kswindlehurst — Wed, 18 Jan 2017 16:10:51 GMT

Thank Enrique,

Yes, I know either of these steps will correct the symptom, but I want to understand the cause. Why this is happening in the first place? How does a Publisher reload alter the qvw in way that the client reload doesn't? And what is it altering?