QlikView

A pie-chart is a representation of values as slices of a circle with different colors. The slices are labeled and the numbers corresponding to each slice are also represented in the chart.…

Bar charts are a very widely used charting method to study the relation between two dimensions in form of bars. The height of the bar in the graph represents the…

QlikView text Object is used to show some descriptive information about the QlikView report being displayed. It can also show calculations based on certain expressions. It is mainly used for displaying nicely…

A Multi-Box represents the list of all the values from multiple fields as drop-down values. Similar to the list box, the selection of a value in Multi Box highlights the related values…

A list box represents the list of all the values of a specific field. Selecting a value in the list box highlights the related values in other sheet objects. This helps in…

QlikView documents are the files that contain all the objects used for the data presentation and analysis. It contains the sheets, variables, data model, source-data connection details, and even the…

The ranges() function in QlikView is used to do a selective sum on chosen fields which is not easily achieved by the sum function. It can take expressions containing other functions as…

The peek() function in QlikView is used to fetch the value of a field from a previous record and use it in calculations. Input Data Let us consider the monthly sales figure…

The Rank() function in QlikView is used to display the rank of the values in a field as well as return rows with specific rank values. So it is used in two…

QlikView Aggregate functions are used to produce aggregate data from the rows of the table. The functions are applied to the columns when creating the load script. Given below is…