Chart showing Continuum of ID on year

[#1]

Hi Group,

I am looking for Chart to Display ID Continuum on button click.
Say I have Condition:
1. Select 2002 and 2004 from Year List Box.
2. Now in Table box it should only display Only ID's present in all 2002 , 2003 and 2004. 
3. If any  ID is not available in 2003 but was available in 2002 and 2004, this ID should not appear in chart.

** Looking for your quick favor..... attached is the sample QVW

--

Thanks & Regards

Ashwin Pagare

[#2]

Hi Ashwin,

The button should apply an advanced filter that compares the current selection of years to the years associated with each ID.  The formula I used in the attached file is

='=GetFieldSelections(Year)=concat(distinct Year,' & chr(39) & ', ' & chr(39) & ')'

I hope that helps.

Regards, Karl

[#3]

Thanks Karl.... its works. 

I really loved the logic you suggested. I was struggling nearby the same but missed out this.  Thanks for the quick help.

--

Thanks & Regards

Ashwin Pagare