Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
prabhas277
Creator
Creator

differences

Hi experts,

What is the difference b/w the dimension and add calculation dimension? explain

2 Replies
swuehl
MVP
MVP

You are probably refering to the dimension tab of a  chart?

In general, a dimension is used to group by your record set to calculate the aggregates.

Dimensions and Measures

As dimension, you can use any field that exist in your data model.

That's where you can click on a field name and 'Add' to the list of dimensions on dimension tab.

But you can also do a transformation of a field, a so called calculated dimension.

For example, your data model only contains dates, but you want to group by Year:

=Year(DATEFIELD)

could be used as calculated dimension then. There are more complex calculated dimensions, but in principle, there are all similar in providing something 1-dimensional (like an array of values) to group your record set.

Kush
MVP
MVP