19 September, 2018
A QlikView document uses at least one sheet on which sheet objects are displayed. Even if a number of sheet objects have been placed on several different sheets, all sheet objects are still fully connected by the QlikView logic.
Different types of Sheet Objects in QlikView are
-Current Selections Box
-Button Text Object
List Box: The list box is the most basic sheet object. It contains a list of all possible values of a specific field. Each row in the list box can represent several records in the loaded table, all with identical values. Selecting one value may thus be equivalent to selecting several records in the loaded table.
Statistics Box:The statistics box is a compact way of showing a numeric field in which the separate records are of less interest than e.g. their sum or average. A selection of statistical functions(Sum, Min, Max, Average, Total Count, Numeric Count, Null Count, Text Count, std dev, Median, Fractile, etc.) are available . When no specific range of values is selected QlikView treats all the values listed in the corresponding field list box (option values) as the sample.
The default name of the box is the same as that of the field to which the selected values belong.
Multi Box: Multi box offers the ultimate solution to the problem of displaying a large number of list boxes on the same sheet.
Table Box: The table box is a sheet object that shows several fields simultaneously. The content of every row is logically connected. The columns may be fetched from different internal tables, letting the user create tables from any possible combination of fields.
Input Box: The input box is a sheet object that is used for entering data into QlikView variables and displaying their values.
Current Selections Box: In the current selections box, selections are listed by field name and field value. Indicators are used for distinguishing between selected and locked values.
Button: Buttons can be created and defined in QlikView to perform commands or actions.
Text Object: Text objects are used for adding information to the document, such as labels etc. They can be moved around and positioned anywhere in the sheet area, even to areas covered by other sheet objects.
Line/Arrow Object: Line/arrow objects are used for adding lines or arrows to the layout.
Slider/Calendar Object: Slider/Calendar objects provide alternative means for selecting field values in QlikView
Slider: A single value, two values or a range of values (depending on the properties of the object) is selected in a field or inserted into one or two variables by means of dragging a thumb tack along the slider background. The thumb tack can also be moved by means of scroll arrows. Some sliders may incorporate a scale and tick marks for navigation.
Calendar: A slider/calendar object in calendar mode appears in the layout as dropdown box with a calendar icon to the right. When clicking on the calendar icon it will expand to a calendar control. It is possible to navigate between months and years by means of the arrow buttons or the month and year drop-down controls. After selecting a date or a range of dates (depending on the properties of the object) in the calendar control the selection will be applied to the underlying field or variable.
Bookmark Object: The bookmark object is a sheet object that is used for displaying bookmarks for selections. Depending on its configuration it can also be used for adding new bookmarks or deleting old ones.
The container is an object that contains other objects. The container can contain all other sheet objects. The objects are grouped together and have common settings for font, layout and caption.
Search Object: Search objects can be used for searching for information anywhere in the document.
1. Text Search The simplest way of searching is text search. QlikView will search for field values matching a text string that you type.
In normal search (no wildcards are used), QlikView will look for words that begin in the same way as the search string. If the search string contains several words separated by blanks, QlikView will interpret it as several search strings and display field values that contain either of the strings.
If wildcards are used, only those records that match the entire search string will be displayed, that is a blank does not imply a logical OR. Wildcards may appear several times in the search string, regardless of their location.
The following wildcards can be used: ?
Fuzzy Search Fuzzy search is similar to standard search, with the exception that it compares and sorts all field values according to their degree of resemblance to the search string.
Fuzzy search is especially useful in situations where misspelling is an issue. It can also help you find multiple values that are nearly identical to each other.
When a fuzzy search is made, a tilde-character (~) is displayed in front of the search string.
If starting a text search with a tilde-character, the text search window will open in fuzzy search mode. The search window will contain the tilde with the cursor placed after it. As you type, all values will be sorted by the degree of resemblance to the search string with the best matches at the top of the list. If you press Enter, the first value in the list will be selected.
2. Numeric Search This is very similar to text search. The only difference is that the search string must begin with one of the following relational operators:
> greater than
>= greater than or equal
< less than
<= less than or equal
3. Associated Search The search box contains a chevron (>>) to the right. If you click it, the search box is expanded to the right and a secondary result set is displayed next to the primary result set. This secondary list contains search matches in other fields. It is now possible to click in the secondary result set and make temporary selections. Such selections will narrow down the result in the primary result set.
4. Advanced Search:If you start your text search with an equal sign (=), you may enter an advanced search expression involving search criteria for associated fields and full Boolean logic.
After the equal sign you can type any valid QlikView layout expression, the expression will be evaluated for each field value in the search field. All values for which the search expression returns a non-zero value will be selected.