Problem with Max[,rank]

[Anonymous]

Hi,

in this thread i asked Expression - Filter for dimension

if i use a dimension in a chart and want to filter the values of the dimension, how can i do it?

The answer was for example

=if(Name='*Samsung*',Name,Null())

Now i want to use Max() in an expression like this:

=if(date = Max(Total date,2),Sales,Null())

The editor shows "ok", but the chart table shows only grey fields.

I test this expression

Max(total date,2)

and this one

=if(date = Max(Total date),Sales,Null())

Both shows the correct data.

What´s wrong in this expression?

=if(date = Max(Total date,2),Sales,Null())

regards,

sam

[sunny_talwar]

What is the dimension here? and I am guessing that you are using this as an expression?

[Anonymous]

I use a chart table, create a new dimension and in the fieldname i write this expression:

=if(date = Max(Total date,2),Sales,Null())

[Clever_Anjos]

You need an aggregation, you have to choose by which field

Maybe this

Aggr(if(date = Max(Total date),date,Null()),date)

[sunny_talwar]

Do you have more than one dimension?

[Anonymous]

yes 8 dimensions

[sunny_talwar]

And are you only looking to get the 2nd highest date across all these 8 dimensions?

[Anonymous]

No, in other dimensions i´m looking for the 1st highest date.

[sunny_talwar]

Not sure I am understanding the requirement... would you be able to share some sample data or a sample app?

[Anonymous]

Yes...