Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

MAX of a date field

I have a field that is set as date.

If i use the following instruction in the expression of a pivot table it works

max(date_field).

If I use the same instruction in the dimension of the pivot I get an error message.

I want to use the result for an aggr fuction, but for the moment my first problem is to make the MAX fuction to work

Anyone can help?

THanks

Andrea

Tags (1)
2 Replies

Re: MAX of a date field

Ciao Andrea,

ogni espressione funziona sulla base delle dimensioni inserite in un oggetto, se inserisci una funzione di aggregazione (Max) nella dimensione, sulla base di cosa dovrebbe essere calcolato il max?

Spiegami cosa vuoi fare e dove, cercherò di aiutarti

jerem1234
Valued Contributor II

Re: MAX of a date field

You can't use aggregation functions in a calculated dimension (i.e. max()). You can use a workaround with the aggr() function. Something like:

aggr(max(date_field), FIELD)

Hope this helps!