Use of Min in calculated dimension

[martynlloyd]

Can anyone tell me why I can't use Min(adate) in a calculated dimension?

='Contract End from ' &  ' ; Contract Types ' & GetFieldSelections([Contract Type])

works fine,

but

='Contract End from ' & min([Contract End]) &  ' ; Contract Types ' & GetFieldSelections([Contract Type])

Does not.

Regards,

M

[Anonymous]

Does it give you an error or the result is not the expected?

Try replacing min([Contract End])   by:

min(Aggr([Contract End], [Contract End]))

Marc.

[JonnyPoole]

Do you want it to be the min out of every date in the chart ,  in the current selection, in the date model ? 

See below for min date in a year and min date in whole chart .  expressions are in the column header:

[martynlloyd]

Hi, the main problem is that I get the error

// Error in calculated dimension

Thanks,

M.

[JonnyPoole]

Can you share a sample (qvw)  ? 

[martynlloyd]

Example attached

[JonnyPoole]

Is this what you need ?

Calculated dimension formula:    =date(aggr(Min(EndDate),Customer))

[abeyphilip]

Hi,

Can you try it using a variable?

Please check attached qvw.

Regards,

Abey

[martynlloyd]

Interesting idea, it certainly solves the syntax error, but no use because the dim has to be dynamic - based on the selection.

Regards,

M.

[abeyphilip]

But where have you set the variable. I hope not in the load script.

Because if it is from the - "Settings -> Variables Overview", those variables are dynamic and it will change as per your selection of the field used in variable definition.

Regards,

Abey