- QlikView for Developers Cookbook
- Stephen Redmond
- 427字
- 2021-08-13 17:08:28
Using the design menus to custom format a cell
There are two design menus that can appear when you right-click an object on the layout. They are:
- Order: This is applicable to all objects, and this menu has a submenu that allows you to adjust the Layer of an object.
- Custom Format Cells: This is applicable only to the three grid objects (Table Box, Straight Table, and Pivot Table), and this menu allows you to apply your own custom color, border, and font options to a cell.
These menu items do not appear by default. There are two ways of making them available. You can either turn on the Design Grid option (from the View menu), or you can turn them on by changing your User Preferences, which we will do in this recipe.
Getting ready
Load the following script:
Load * Inline [ Country, Sales, Costs USA, 1203, 1043 UK, 987, 995 France, 1118, 1022 Germany, 876, 754 ];
How to do it…
Use the following steps to custom format a cell in the table:
- Create a straight table with Country as dimension and add the following three expressions:
- Click on Finish to save the chart.
- From the Settings menu, select User Preferences and click on the Design tab.
- Click on the Always Show Design Menu Items option and click on OK.
- Right-click on one of the Total Margin values for a country (for example, 160 for USA) and select Custom Format Cell from the menu.
- Click on the Background Color button and change the Base Color, Fixed to an RGB value of 245, 245, and 245. Set the Apply change to option to Current Expression and click on OK.
- Right-click on the total value for Total Margin (in this case, 370) and select Custom Format Cell. Set the Text Size to 120 % and turn on the Italic checkbox. Click on OK to make the change.
- Similarly, right-click on one of the countries (for example, Germany) and select Custom Format Cell. Turn on the Bold option and click on OK:
- Edit the properties of the chart and go to the Style tab. Note that the Current Style is set to [Custom].
How it works…
This is quite simple, turning on the option in the User Preferences allows us to see the menu and that then allows us to make custom format changes to our tabular chart.
There's more…
If you change the Current Style option in the chart properties to one of the preset styles, it will remove all your custom settings.
推薦閱讀
- 中國新股民必讀手冊(2015年最新版)
- 汪博士詳解PMP?模擬題(第4版)
- 新形勢下中國投入產(chǎn)出核算的變革與實(shí)踐
- Citrix XenApp? 7.5 Desktop Virtualization Solutions
- 企業(yè)能源審計與節(jié)能規(guī)劃
- 財務(wù)審計實(shí)務(wù)指南
- AO2011實(shí)用手冊
- 中國政府統(tǒng)計問題研究
- 振蕩指標(biāo)MACD:波段操作精解(升級版)
- 成功通過PMP(第3版)
- 政策建模技術(shù):CGE模型的理論與實(shí)現(xiàn)
- Business Intelligence Cookbook:A Project Lifecycle Approach Using Oracle Technology
- Oracle Primavera Contract Management,Business Intelligence Publisher Edition v14
- Managing Virtual Infrastructure with Veeam? ONE?
- Getting Started with Citrix? Provisioning Services 7.0