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.




 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.




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.



 
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.




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.



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




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.




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




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.




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




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




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




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




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.



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




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.



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



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.




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



Summary

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