Axis and measures

[louise119]

If you use a field for an axis, you will see a value, but if you use it for a measure, you may not see a value.

Do you know the reason why?

[rwunderlich · Accepted solution]

When you use a field for a Dimension (Axis), each unique value of the field will generate a new row in the table. 

Measures do not generate new rows.  If a fieldname used as a measure has only one value for the Dimension row. that value will appear.  If the field has multiple values, you must use an aggregation function to define how to handle the multiple values. For example:

Sum(fieldname)

Maxstring(fieldname)

See:

https://community.qlik.com/t5/Design/Use-Aggregation-Functions/ba-p/1475833

https://community.qlik.com/t5/Design/It-s-all-Aggregations/ba-p/1465669

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com