QlikView Dimensions and Measures – How to Use & Create
In our last session, we discussed QlikView Dashboard. Now, we are going to explore QlikView Dimensions Tutorial, in which we study how to use QlikView Dimensions and Measures.
So, let’s start QlikView Dimensions and Measures.
2. Define – QlikView Dimensions & Measures
Every time you work with data in a tabular form, you are dealing with dimensions and measures in one way or the other. In our sample data of product records having fields like Product ID, Product Line, Category, Quantity and Cost.
QlikView Dimensions – The fields with informative values like ID, line, category are called Dimensions. Dimensions are always descriptive text values.
QlikView Measures – The fields upon which calculations can perform like Product cost and quantity are called Measures. Measures are always a calculated result of the values of dimensions or field. In a broad sense, Measures are numerical values upon which mathematical calculation can perform.
Do you know How to Create QlikView Bar, Pie Chart & TextBox?
3. How to Use Dimensions & Measures in QlikView?
We deal with QlikView measures and dimensions every time we work with data sets, make tables, charts etc. Knowing the concept of QlikView dimensions and measures will make dealing with various kinds of information during data analysis easy.
Let us elaborate our point by creating a straight table chart using the data file product records.
Step.1 Input Data
Load the script in the memory of Qlikview.
We can view the table fields in table view by pressing CTRL+T in the script editor. Here we can clearly distinguish between QlikView dimensions and measures.
Step.2 Save the file
Now, save the file in .qvw extension and reload the script with the icon or CTRL+R. Create the CHART sheet object and select STRAIGHT TABLE chart type.
Step.3 Select the dimension
Step.4 Apply an Expression
The function or expression will apply to a field that is classified as a measure.
Step.5 Click on FINISH
Click > Finish to see the final result i.e. a straight table. This table shows the sum of cost of distinct product lines along with the sum of total revenue made.
So, this was all about QlikView Dimension and Measures Tutorial. Hope you like our explanation.
Hence, we studied QlikView Dimensions and Measures are very important and fundamental entities. Moreover, we covered how to use dimensions and measures in QlikView. For more QlikView Tutorial, stay tuned and share your feedback with us!. We will definitively get back to you.
Related Topic – QlikView Navigation Pane