Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
kswindlehurst
Contributor III
Contributor III

Color variables invalid after Publisher reload

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?

2 Replies
enriquem
Creator
Creator

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.

Kind Regards,
Enrique Mora.
kswindlehurst
Contributor III
Contributor III
Author

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?