Filter records in a table chart

[marsmike]

I have a table chart in my app that that has multiple records with the same primary key but with different dates.  So it might look like this:

14725836     5/20/2014

14725836     5/21/2014

14725836     5/23/2014

I would like to only display the record with the latest (most recent) date.

Is there a way to do that within the table properties?

Thanks,

Mike

[#2]

I think, you may need to use one of those options:

- dimension limits,

- expression like FirstSortedValue()

- set analysis with rank()

regards

Darek

[maxgro]

did you try a chart with?

dimension      your primary key field

expression     max(your date field)

[marsmike]

I'm not really good with set analysis.  I was hoping for something easier.  I tried the dimension on the key field and max(your date field).  That gives me the latest date.  But I failed to mention that there are multiple primary key records, like this:

14725836     5/20/2014

14725836     5/21/2014

25836914     5/15/2014

25836914     5/19/2014

36914725     5/10/2014

36914725     5/17/2014

So, for each primary key I need the latest date.  Sorry for not explaining that.

Mike

[maxgro]

like this?

[marsmike]

Much better!

Is there a way to remove the duplicate entries?

Thanks,

Mike

[marsmike]

Thoughts, anyone?  Is there to remove the duplicate entries after using the expression above?

[maxgro]

this?

[marsmike]

Awesome!

Is the QVW updated?

[maxgro]

yes now