Load BackGround Color In QlikView Script

Introduction

This article describes how to set a background color within a QlikView Script. You can use this technique to maintain a persistent color.

Use the following procedure to set the background color of a QlikView Script.

Step 1: Open the QlikView Application:
In the first step we need to open QlikView and go to File-> New. The following this window will then be opened.

After clicking New option


 Step 2: Open Edit Script Window:
The next step is to open the edit script window from File-> Edit Script. This window will then be opened.

window of edit Script


Step 3: Open the table files:
The next step is to open the table files and open our Excel file and click on the Open button.

table files

 
Step 4: Open File Wizard Type:
After opening the Excel file the file wizard type window will be opened then click on the Finish button.

file wizard type


Step 5: Code of edit script:
After this process it shows the code of the Excel table that you have opened in the table files and click on the Reload button to execute the code.

reloading

Step 6: Save QlikView file:
After reloading the code, save the QlikView file and click on the Save button.

save file


Step 7: Sheet Property Window:
After saving the file the next step is to select the field from the sheet property window and click on the OK button.

select field


Step 8: Main Window
: This window will show the Excel sheet table that you have imported into the table files.

main window


Step 9: Add A chart:
To add a chart  right-click anywhere in the blank white sheet and select New sheet object and select chart.

select chart


Step 10: General Window
: After adding a chart the general window will be opened and click on the Finish button.

general window


Step 11: Add Dimension:
The next step is add a dimension for fields and click on the Next button.

Add dimension


Step 12: Edit Expression:
After adding a dimension the edit expression window will be opened and add an expression then click on OK.

edit expression


Step 13: Expression Window:
the expression window will be opened and click on the Finish button.

exp


Step 14: Set background color:
Now the major step is to set the background color of the QlikView Script then go to the properties of the QlikView Script.

set color

Step 15: Chart Property Window:The chart property window will be opened and go to the Colors bar.

property window


Step 16: Color property window:
The color property window will will be opened; from here you can change the background color of the QlikView Script, by default the color will be white and it is fixed.

color property

When clicking on the background color the color area window will be opened.

color area

When clicking on the color area then the color window will be opened; then select a color from of choice and click on the OK Button.

color


Step 17: Final Window:
This is the final window; you can now see the background color that has been changed.

final

Summary

These are the basic steps that shows how to change the background color of the QlikView Script.