3.3.2 QlikView Data Sets

Add a new Data Set and fill in all required fields: 

Applications list - allows to choose an application from the liדt of applications returned from related Data Source.

Friendly name - the user can choose an alias that will be used instead of the QlikView application  name in the "Selected columns" area in the column "Table".

Advanced - allows to use a Variable instead of original application name. Should be in  format @variable_name;.

Reload Metadata - refreshes the QVW application's data and creates *.csv files (in the path set in "System Admin -> System Settings -> General Settings -> System Properties -> QlikView -> QlikView Temporarily Files Location") for all Bookmarks, Objects and Sheets related to chosen QVW application. If the *.csv file(s ) already exists => it will be updated.

Schema - choose suitable option: View/ Model/ Flow/ Multiple Values.

Schema View:

Any value(s) chosen in the fields Bookmark, Sheet Name, Object Type - will filter QlikView Object ids.

 

Bookmark - choose a Bookmark from the list of exiting Bookmarks in chosen QVW application in order to filter the Objects.

Sheet Name - choose a Sheet from the list of exiting Sheets in chosen QVW application in order to filter the Objects:
 

Object type - choose object type from the list of objects (supported by quilliup) in order to filter the Objects:

 

QlikView Object - choose needed Object by id from shown list (values depend on filters chosen in previous fields: Bookmark, Sheet Name, ...) and click Refresh Columns. A *.csv file with all object's columns will be created. If  *.csv file already exists => it will be recreated/refreshed.

Note: if the column name contains a comma => for quilliup it is invalid and a warning message will be shown.

Schema Model:

QlikView Object -choose needed Object by id from shown list and click Refresh Columns. A *.csv file with all object's columns will be created. If  *.csv file already exists => it will be recreated/refreshed.

Schema Flow:
 

Schema Flow allows to build you own procedure using available action type (field "Type") and QVW Object's id(s), for example. 

Schema Multiple Values:
Allows to create a few Values, each value can be composed of several actions, for example:
 

Add Value button  - create a new value of conditions.
Name (required) - suitable name for a specific value.

Add Action - choose a type of action from a list of actions to create a condition. 

QlikView objects supported by quilliup:

• Bar chart
• Combo chart
• List box - filter contains many list boxes 
• Scatterplot
• Table
• KPI
• Pie chart
• Gauge
• Text-image
• Line Chart - isn’t supported if contains more than one dimension
• Pivot-table - isn’t supported if contains more than one dimension

In case if any of these objects contains more than one dimension, an error message will appear: "The selected object contains more than one dimension" (when it's a pivot table or a line chart etc server can see that when it gets more than one dimension it doesn't get all the columns (only the measures), so it’s caught and returns an error message that there is more than one dimension).

• Map and tree map types aren't supported.

• In filter pane, its' items are supported and not filter pane as an object.

• The default is to present only objects with titles (checkbox “Show Only Objects With Title”).

Alternative Dimensions & Measures

If your object includes Alternative Dimensions / Measures - they won't be shown in quilliup.

Only the main dimension(s) / measure(s) are supported.