14 Replies Latest reply: Jul 4, 2017 7:24 PM by Sunny Talwar RSS

    Problem with Max[,rank]

    s Walter

      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