QlikView

Power BI supports a large range of data sources. You can click Get data and it shows you all the available data connections. It allows you to connect to different…

Circular Reference occurs when we can traverse from one table to another using two or more different paths. This means you can join Table1 with Table2 directly using a column or…

The mapping table is a table, which is created to map the column values between two tables. It is also called a Lookup table, which is only used to look…

In QlikView, many times we need to create a calendar reference object, which can be linked to any data set present in QlikView's memory. For example, you have a table…

The concatenation feature in QlikView is used to append the rows from one table to another. It happens even when the tables have different numbers of columns. It differs from…

The keep command in QlikView is used to combine data from two data sets keeping both the data sets available in memory. It is very similar to joins we covered…

Joins in QlikView are used to combine data from two data sets into one. Joins in QlikView mean the same as in joins in SQL. Only the column and row…

QlikView's Set Analysis feature is used to segregate the data in different sheet objects into many sets and keeps the values unchanged in some of them. In simpler terms, it…

Pivot Tables are widely used in data analysis to present the sum of values across many dimensions available in the data. QlikView's Chart option has the feature to create a…

Straight Tables are the most widely used sheet objects to display data in QlikView. They are very simple yet powerful with features like column rearrangement, sorting and coloring the background,…