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.
Charts are graphical representations of numerical data. Here are the list of charts in qlikview:
This is the most basic chart type. Each x-axis value corresponds to a bar. The bar height corresponds to its numerical y-axis value. Bar chart is used for Quantitative analysis and for Rank Analysis. The Maximum Number of Dimensions for Bar Chart is Three.
Mekko charts present data using variable width bars. They can display up to three levels of data in a two-dimensional chart. Mekko charts are useful in such areas as Market Analysis.
The line chart is essentially defined in the same way as the bar chart.
Line charts present data as lines between value points, as value points only or as both lines and value points.
Line charts are useful when you want to show changes or Trend Analysis or Movement Analysis.
The combo chart allows you to combine the features of the bar chart with those of the line chart: you can show the values of one expression as bars while displaying those of another expression as a line or symbols. Combo charts can be used to display various units of measurements
Radar charts could be described as line charts where the x-axis is wrapped around 360 degrees and with one y-axis for each x-value. The result is similar to a spider web or a radar screen. Maximum number of dimensions for Radar chart is One.
The scatter chart presents pairs of values from two expressions. This is useful when you want to show data where each instance has two numbers. Maximum number of dimensions for Scatter chart is Two.
The funnel chart is typically used for showing data in flows and processes. From a display standpoint it is related to the Pie Chart. The chart may be shown with either segment height/width or segment area proportional to data. It is also possible to draw the chart with equal segment heights/widths without regards to data points.
The grid chart is similar to the scatter chart but plots dimension values on the axes and uses an expression to determine the plot symbol. A special mode makes it possible to show a third dimension in the form of small pie charts as plot symbols.
The pivot table is one of the most powerful tools for analyzing data. It offers substantial functionality but is still easy to use. Pivot tables show dimensions and expressions in rows and columns, for example in cross tables. The data in pivot tables may be grouped. Pivot tables can show partial sums. Dimensional Limits Option is not available in Pivot Table. Accumelation and Hiding of Colomns is not possible in case of Pivot Table.
In opposition to the pivot table, the straight table cannot display sub-totals or serve as a cross table. On the other hand, any of its columns can be sorted and each of its rows contains one combination of dimension(s)+expression(s). Dimensional Limits Option is available in Straight Table. Accumelation and Hiding of Colomns is possible in case of Straight Table.
Gauge charts are used to display the value of a single expression, lacking dimensions.
Key Performance Indicators (KPIs) provide a way to quickly identify, manage, and respond to the performance of your business’s strategic or operational goals.
A KPI is a metric that is tied to a target. The KPI usually represents how far away a metric is from its pre-determined target. The KPI score and its indicator are designed to let a business user know at a glance if results are on target or off target. For example, one commonly-used measure of retail success is same-store sales. If sales in a particular store increase each year, management views it as a solid performer. If the store performs less well than it did in previous years, management is likely to be concerned. A reasonable goal might be a 10% increase in sales each year for each store, and the KPI would be set accordingly.
Using Indicators, you can immediately respond to critical situations that need attention. For example, if the “% of Sales”, “% Overdue”, or “Expenses vs. Target” Indicators reveal a negative change, the business user can take a closer, more detailed look to see what is causing the downturn. Indicators help you attend to your critical metrics in a more proactive manner.
The Speedometer Gauge provides an effective way to visualize how a KPI falls within the ranges of poor, mediocre, and acceptable business rule standards. For example, a Margin % of 18.37% indicates a poor performance (red). In addition, the Speedometer Gauge can be monitored for abrupt or subtle changes to the indicated value.
A defining characteristic of a Linear Gauge is that it uses a linear scale (divisions between the units are equal, like a ruler) as a backdrop for vertical or horizontal facing pointer(s) along a range of data.
Test Tube Gauge:
The Test Tube Gauge provides an excellent indicator showing, the percentage achieved of contributing toward a goal. Data segments can be further enhanced by providing colors indicating the data’s progress toward that goal.
Traffic Light Gauge:
The Traffic Light Gauge provides an immediate way to visualize when a data value achieves a certain outcome. In the example above, sales margin of each region will display the following traffic lights
(Yellow) 40 – 42%
Text Gauge: Although not a Gauge chart, the Text Object is an Indicator producing one value that commands immediate attention.
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.
Different types of searches in QlikView
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: ?
- For any single character *
- For Zero or more characters ^
- For Whole string
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.