Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Max in Dimension Table

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

  • MAX(DATE(date_ship))

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

Anyone knows waht's happening?


3 Replies

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

Aggr(Max(date_ship), date_ship)


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).

Not applicable

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

Aggr(Max(Date_Ship), <DimensionFieldName>)