topic Re: Max in Dimension Table in QlikView

Max in Dimension Table

Wed, 03 Feb 2016 19:33:41 GMT

I have the following code in dimensions tab on my pivot table:

Where date_ship is a datetime variable. But it give me an error like "Error in Calculated Dimension"

Anyone knows waht's happening?

Thanks!!!

sunny_talwar — Wed, 03 Feb 2016 19:38:05 GMT

To use Max in your dimension you will need to use with Aggr() function. Try this:

Aggr(Max(date_ship), date_ship)

swuehl — Wed, 03 Feb 2016 19:38:07 GMT

You would need to use something dimensional as dimension, not a scalar.

Like a field, or

=Aggr( Date(Max(date_ship)), DimensionForMaxDateField)

Replace the aggr() dimension with appropriate field name(s).

Wed, 03 Feb 2016 19:41:25 GMT

You can't use aggregation function directly in Dimensions expression. You need use AGGR function

Aggr(Max(Date_Ship), <DimensionFieldName>)