Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Eduard23
Contributor III
Contributor III

INVALID DIMENSION

Hi All,

Currently i'm having INVALID DIMENSION though my expression have no error. I need to divide the value from 1 field to the Qty Shipped.

 

=(ITEM_UOM_CONVERSION_FACTOR)
/Num(
(Sum({$(eSales_Qty)}UNITS_PRIMARY_QUANTITY_SHIPPED)
+Sum({$(eFOC_Qty)}UNITS_PRIMARY_QUANTITY_SHIPPED)
+Sum({$(eReturn_Qty)}UNITS_PRIMARY_QUANTITY_SHIPPED)
+Sum({$(eBonus_Qty)}UNITS_PRIMARY_QUANTITY_SHIPPED))
,'#,##0')

Labels (2)
1 Reply
marcus_sommer

Aggregations aren't possible within a dimension unless they wrapped with an aggr() which makes it to a calculated dimension. Means something like:

aggr(YourExppression, Dim1, Dim2)

whereby Dim1 and Dim2 are placeholder for the dimensionality in which context the calculation should happens - often it are the other dimensions from the object but sometimes it may also a granularity deeper.