Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
marsmike
New Contributor III

Filter records in a table chart

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

Tags (3)
1 Solution

Accepted Solutions
marsmike
New Contributor III

Re: Filter records in a table chart

Massimo, thank you very much, this is great!

You are THE MAN.

10 Replies
Not applicable

Re: Filter records in a table chart

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

- dimension limits,

- expression like FirstSortedValue()

- set analysis with rank()

regards

Darek

MVP
MVP

Re: Filter records in a table chart

did you try a chart with?

dimension      your primary key field

expression     max(your date field)

marsmike
New Contributor III

Re: Filter records in a table chart

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

MVP
MVP

Re: Re: Filter records in a table chart

like this?

1.png

marsmike
New Contributor III

Re: Filter records in a table chart

Much better!

Is there a way to remove the duplicate entries?

Thanks,

Mike

marsmike
New Contributor III

Re: Filter records in a table chart

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

MVP
MVP

Re: Filter records in a table chart

this?

1.png

marsmike
New Contributor III

Re: Filter records in a table chart

Awesome!

Is the QVW updated?

MVP
MVP

Re: Re: Filter records in a table chart

yes now