0 Replies Latest reply: Sep 26, 2014 2:53 PM by Fernando Silva RSS

    Retrieve a value based on two dates comparison using Set Analysis in a table

      Hi guys,

       

      Im stuck with this issue for over a month, as my questions says I want to retrieve a value based on two dates comparison using Set Analysis in a table, in detail, I want to get a value [Avance Esperado]  from the Max([Fecha de Avance])

       

      If I use the expression

      =Max({$<[Fecha de Avance] = {"$(=Max([Fecha de Avance]))"}>} [Avance Esperado])

      The row "Avance esperado" shows value only where the date matches with the maximum date in the whole document, not per [Proyecto], as you can see in the image below:

       

      Table.png

       

      If I use instead this expression:

      =Max({$<[Fecha de Avance] += {"$(=Max([Fecha de Avance]))"}>} [Avance Esperado])

      The result seams to be right:

       

      Table2.png

      But if you check on the source document which is excel, you realize it is picking the maximum value for [Proyecto] but no with the matching maximum date:

      Source.PNG.png

       

      So the value picked in [Avance Esperado] should be 87.50% as marked with blue, due the date 17/09/2014 is the maximum date for Janssen - Kronos project, instead it is picking 100% as marked in red.

       

      I am attaching the qvw file, and the xlsx source file.

       

      Can you help me to solve this?

      Thank you very much.