Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
has anybody loaded the default layout settings from a qvw-document and could provide some tipps or script? This isn't directly possible but per export layout within a xml-file it worked. But there are a lot of settings and I want only the default settings from document for a few main features like font-type, font-size, tab-color, background-color, border yes/no ... perhaps on sheet level also but not all settings.
Thank you for your help.
Marcus
You can create a theme and then apply that to any document you're working on. The following is from QV help:
A QlikView layout theme is a set of formatting properties that can be applied to a whole QlikView layout or to parts thereof. Theme files are coded in xml and normally kept in a special QlikView theme folder under Windows' Application Data folder for the active user.
Themes can significantly reduce time and effort needed to make a QlikView layout good-looking and consistent. They can also be used to enforce a certain graphical style within a company etc.
A QlikView theme file consists of individual sections for each type of layout object (document, sheet and all different types of sheet objects). Each of these sections has three sub-sections, one for object type specific properties, one for border/caption properties and one for printer setting properties (only for printable object types). Each section and sub-section can be created or replaced separately using the Theme Maker Wizard, without affecting other sections in the theme file.
A theme section is created as follows:
- Format a specific object according to your wishes
- Use the Theme Maker Wizard to extract selected properties from that object and insert them into a theme file
General purpose themes are themes which have defined sections for all different object types. There are a number of such themes provided with the QlikView installation package.
If you want to create such a theme yourself you must:
- Format Document Properties to your liking
- Format the Sheet Properties of one sheet to your liking
- Create (if necessary) and format one sheet object of each type to your liking. Caption/Border properties typically only need to be formatted for once one sheet object type which usually uses caption (list boxes, charts etc) and once for one sheet object type which normally goes without caption (text object, button etc).
- Run the Theme Maker Wizard creating a new theme and insert properties from the first of the formatted entities listed above (order doesn't matter).
- Run the Theme Maker Wizard repeatedly, once for every remaining formatted entity listed above.
It is possible to create themes for specific uses. Depending on the purpose these may only need to define a small sub-set of the available theme sections and sub-sections. As an example, you may define a theme which sets only chart objects to a given size and position on the sheet. In order to do that you need to define a theme with one single property from the caption/border group only for charts, i.e. one single sub-section.
QlikView layout themes can be applied either manually at any given time or automatically every time a new layout object is created. Themes can be applied to
- individual sheet objects
- a group of sheet objects
- a sheet
- the whole document
Do as follows:
- Activate the sheet object by clicking on it.
- Open the Properties dialog for the sheet object from the context menu.
- Go to the Layout page
- Click on the Apply Theme... button
- Select a theme in the browser dialog that opens
- Click OK
All properties in the theme which are applicable to the selected sheet object will now be applied. If you want to apply a theme to a group of sheet objects, you must first make them all active by means of Shift+clicking or lasso selection.
Do as follows:
- Activate the sheet by clicking on its tab.
- Open the Sheet Properties dialog from the Settings menu.
- Go to the General page
- Click on the Apply Theme... button
- Select a theme in the browser dialog that opens
- Click OK
All properties in the theme which are applicable to the selected sheet will now be applied. Additionally the theme will also be applied to all sheet objects on the sheet.
Do as follows:
- Open the document or activate it.
Hi Nicole,
it is a great idea to simplify this task with using and reading from theme-files. Had anyone done it already? I mean read, transform and categorize these data within a normal table-structures and could provide some scripts? It would save some time. Many thanks.
- Marcus