QlikView – Cross Tables
While analyzing data, we come across situations where we desire columns to become rows and vice-versa. It is not just about transposing, it also involves rolling up many columns together…
While analyzing data, we come across situations where we desire columns to become rows and vice-versa. It is not just about transposing, it also involves rolling up many columns together…
Many times, we need some data to be generated programmatically by the software being used, which is not coming from a source. For example, 100 random numbers or just the…
A Synthetic Key is QlikView's solution to create an artificial key when there is ambiguity about which key to use between two tables. This situation arises when two tables have two or…
A start schema model is a type of data model in which multiple dimensions are linked to a single fact table. Of course, in bigger models, there can be multiple…
Dimensions and Measures are fundamental entities, which are always used in data analysis. For example, consider the result of the analysis, “what is the percentage change in volume of sales for…
The Rotating table in QlikView is similar to the column and row transpose feature in Microsoft Excel but with some additional options. We can transpose columns in multiple directions and…
Column Manipulation is a type of Data Transformation in which a new column is populated with values from an existing column, which meets certain criteria. The criteria can be an…
The Fill function in QlikView is used to fill values from existing fields into a new field. Input Data Let us consider the following input data, which represents the actual and forecasted…
Data Transformation is the process of modifying the existing data to a new data format. It can also involve filtering out or adding some specific values to the existing data…
A Dashboard is a powerful feature to display values from many fields simultaneously. QlikView's feature of data association in memory can display the dynamic values in all the sheet objects.…